I am facing an issue in loading an excel sheet which have a dynamic Column. It changes when ever a new data is entered in the sheet or to that particular column.
| ID | Name | Count=0 |
Over here the column "Count=0" the 0 will increase as we add data into the sheet. So for every time the name will change so how can I load this column? 0 is nothing but sum(entire row).
Use following steps:
1. open script of an empty qvw (or mine or anbus)
2. delete load statement and load your table file again (with the dynamic field)
3.in the file wizard change a) header size to "Lines" and "1"
b) Lables to "None"
and you will see in the preview what QV will change
and change column names manually like you want
after that the file can be load without problem also when lines are created.
Use a CROSSTABLE () LOAD. The label will become a value. In a subsequent RESIDENT LOAD you can convert the string part into a real date value.
Of course, this is a lot of work if there is only one column with a date. The code's only efficient if you have more than one date column.
Yes nearly every reload the date in column name will change.
I did as Peter Cammaert said .
Used a Crosstable , resident and variable value.
Thank you two for shearing knowledge.