Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add excel fields automatically???

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.

3 Replies
andreypico
Contributor III
Contributor III

Hi.

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

Not applicable
Author

Hi,

 

    Sorry i didn't understand explain clearly.

Thanks,

Ashok.

jagannalla
Partner - Specialist III
Partner - Specialist III

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