CSV file specifications are composed of:
1. QRT name – the name of the sheet where you wish to import the file.
2. Named range name
3. Data (number and text) separated by a comma.
There is a structure that must be followed and this is different for static (identified by first header row being text of “FIXED” and list (identified by first header row, first part being text of “LIST”) QRTs.
Here’ s an example of LIST case (a type of QRT structured in a table format.), contents of the CSV file will be:
LIST, S.06.03.01
C0010,C0020,C0030,C0040,C0050,C0060
BRWPXWHM7,CAU/INST,4,AA,3,1037406.3
BRWPXWHM7,CAU/INST,4,AA,2,56
In QRT it would look like this:
In STATIC case, the contents of the CSV file will be:
FIXED
S.02.01.02,_C0010_R0030,0
S.02.01.02,_C0010_R0040,0
S.02.01.02,_C0010_R0050,0
S.02.01.02,_C0010_R0060,106762
S.02.01.02,_C0010_R0070,10000756
It would look like this in the QRT:
Post your comment on this topic.