topic How to add excel fields automatically??? in QlikView

How to add excel fields automatically???

Tue, 26 Feb 2013 07:30:55 GMT

Hi All,

we are maintain data in excel month-wise means months as a columns.

for example right now we have apr,mar,may data in excel, in future they will add june,july.........i need to update this columns also

automatically.

how can any one advice me.

Thanks,

Ashok.

andreypico — Tue, 26 Feb 2013 07:42:30 GMT

Hi.

You can once load data with one month-wise and left join other month in cycle.

Tue, 26 Feb 2013 08:12:15 GMT

Hi,

Sorry i didn't understand explain clearly.

Thanks,

Ashok.

jagannalla — Tue, 26 Feb 2013 08:22:15 GMT

Hello,

Just change the code of your script to

Month:

Load * from sales.xlsx;

instead of

Month:

Load apr,mar,may from sales.xlsx;

Hope it helps you

Cheers!!

Jagan