5-4. Converting data

At the point of data formatting, the data can be converted into a new format by calculating, joining or scoring. One thing to keep in mind is that if a "data convert" property is added to your configuration, BYOR assumes that the converted data is the data being used to apply filters and build visualizers. It means that if you have a field in your raw data that is not added to the converted data, things may not work the way you imagined. 

Format

"data convert":[
{"type":"convert type","field name":"new field name","raw field":"value in raw data"},
{"type":"convert type","field name":"new field name","raw field":"value in raw data"}
]

Options

Just add a field in raw data, with a new field name:
{"type":"raw","field name":"Chromosome","raw field":"chromosome"}

Join two fields in raw data into a new field:
{"type":"join","field name":"Locus","fields to join":["chromosome","position"],"join by":":"}

Join multiple fields in raw data into a new field:
{"type":"join multi","field name":"Variant ID","fields to join":["chromosome","position","reference","alt"],"join by":[":","_","/"]}

Replace characters in raw data into a new field:
{"type":"replace characters","field name":"1-star Genes","raw field":"gene_1_star", "replace":[{"from":";","to":", "}]}

Create a new field by calculating values in raw data. Only the "-log10" option is available at this point (02/10/2022):
{"type":"calculate","field name":"-log10(P-Value)","raw field":"pValue","calculation type":"-log10"}

Create a new field by calculating scores of the values in the listed fields. Only boolean values (true/false, yes/no or 1/0) can be calculated:
{"type": "score columns","field name": "Score","fields to score": ["DEPICT", "MAGMA", "PoPS", "OMIM", "Gene_nearest_COJO", "eQTL_COJO", "Functional_COJO"],
    "score by": {"DEPICT": { "type": "boolean", "value to score": { "yes": 1, "no": 0} },"MAGMA": { "type": "boolean", "value to score": { "yes": 1, "no": 0} },"PoPS": { "type": "boolean", "value to score": { "yes": 1, "no": 0} },"OMIM": { "type": "boolean", "value to score": { "yes": 1, "no": 0} },"Gene_nearest_COJO": { "type": "boolean", "value to score": { "yes": 1, "no": 0} },"eQTL_COJO": { "type": "boolean", "value to score": { "yes": 1, "no": 0} },"Functional_COJO": { "type": "boolean", "value to score": { "yes": 1, "no": 0} }}}