topic Re: Dynamic Column Names in QlikView

Dynamic Column Names

Wed, 23 Sep 2015 09:25:39 GMT

Hi All,

I'm facing a problem, to load dynamic column names.

I'm using an excel file, which will update by every month, so column names will get change (no change in data).

How to load it dynamically.

Thanks in Advance

Pavan

tresB — Wed, 23 Sep 2015 09:31:53 GMT

You can load all fields like:

Load * From <>;

Or using field positions, like:

Load

@1 as Field1,

@2 as Field2,

...

From <>; // In this case you have to remove the column header unsing trnasformation.

dmac1971 — Wed, 23 Sep 2015 09:32:46 GMT

Tresesco has the idea, or refer to

Wed, 23 Sep 2015 11:13:09 GMT

Thanks for the quick reply,

But, here my column names will get change for every month.

Like:- last month file has all the column names and Month name. eg:- Code Aug-15. this month it will come as Code Sep-15.

Please help to manage in this case.

Thanks in Advance

Pavan