Loading Dynamic Column Name

[jyothish8807]

Hello All,

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.

eg:

|  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).

Regards

KC

[kushalthakral]

Dear Jyothish

Can you please give an example for better understanding like a table and its content

Regards

Kushal Thakral

[jyothish8807]

Hi All,

PFA Spreadsheet. In this sheet when ever you enter a number in Count Column the count changes.

Regards

KC

[rustyfishbones]

I am not sure you can dynamically change the field

[kushalthakral]

Hi Jyothish

Why dont you try the header in Qlikview GUI, at script level it is not possible but at GUI level you can create it.

Regards

kushal

[jyothish8807]

But I am not able load that that field into qlikview, every time when I reload, the field name changes because someone from user side is updating the sheet.

Any solution for this will be really helpful.

Regards

KC

[rustyfishbones]

You will need to change the column name in excel to something generic

and create the expression in Qlikview

You cant have a changing field name being imported as the script will fail.

Call this field something generic in Excel like Count and don't change it

Regards

Alan

[jyothish8807]

Hmm now its tough since there are more than 100 sheets and all are being used. I cant go back to 100 sheets and make changes. Any way thanks a lot for the help.

Regards

KC

[r_wroblewski]

Hi Jyothish

what you can do is to ignore the header for the excel files for load script.

Regards,

Ronny

[anbu1984 · Accepted solution]

LOAD A As ID,

    B As Name,

    C As Count

FROM

(ooxml, explicit labels, header is 1 lines, table is Sheet1);