Dynamic Column Names

[#1]

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

[tresesco]

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]

Tresesco has the idea, or refer to

Re: excel column selection

D

[#4]

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