I have a csv dateset with 36 month-ends horizontally and would like to convert it to rows. See below sample dataset.
any load script ideas?
desired output :
New month end dates means new rows added to the file. you do not have to change anything to the script what petter suggested. Use his script and when ever the new rows added to the file and you run this script, it will take care of the front end.
VIshwarath, Peters solution works If the input file is static.
But next month when I get the input file with one more month end (one extra column ) don’t I have to manually add the date to script?
You can try this.
(ooxml, embedded labels, table is Sheet1)
CrossTable(DateField, Sales, 1)
Drop Table tabFields;
So just add some dummy date field in your excel and just refresh this above script it should automatically pick up all the values.
one thing is crucial, the positions of the columns before the first Date field must don't move, so here the STATE column should always comes first. then you can add as much Date columns as you want.