You have a data file already formatted in a way you wanted. The headers are worded correctly. No columns need to be removed or joined to another column. The table contents do not include hyperlinks. In this case, you can skip the configuration step and leave the Data Table Format field empty. The research portal will load and render your data in a table.
However, if you want to make any changes to the way your data are presented in the table, you can configure the formatting in the Data Table Format field. In the following pages, you will find options for formatting your data.
One thing to keep in your mind is that, if any 'data convert' configuration is added to the field, the research portal's rendering system will ignore the format in the raw data. For example, if you have the following data which has 6 columns.
CHR,POS,REF,ALT,RSID,PVAL
1,721290,G,C,rs12565286,3.8345e-02
1,976963,A,G,rs150359724,4.3785e-03
1,1120431,G,A,rs1320571,2.3373e-02
You want to join CHR and POS column to create LOCUS column. This case, the research portal will create a new set of data with only a LOCUS column to render in the data table, unless other columns are added in the configuration. Here is an example configuration with CHR and POS columns joined to Locus, and name changes:
{
"data convert":[
{"type":"join", "field name":"Locus","fields to join":["CHR","POS"],"join by":":"},
{"type":"raw","field name":"Reference Variant","raw field":"REF"},
{"type":"raw","field name":"Altered Variant","raw field":"ALT"},
{"type":"raw","field name":"RSID","raw field":"RSID"},
{"type":"raw","field name":"P-Value","raw field":"PVAL"}
],
"top rows":["Locus","Reference Variant","Altered Variant","RSID","P-Value"]
}
In this example, the 'data convert' section specifies the column joins and new column names. The 'top rows' section specifies the fields to be rendered.
In the following pages, we will discuss the options for 'data convert.'