Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
meera__
Contributor
Contributor

How to auto-rerun script for different files?

Hi, I have just started using qliksense and I don't know to proceed with this.

There are data from different countries.

Eg. India:

columns: customerID, Date, Amountspent

customerID for India has a unique prefix 'IN' so it would look like this, IN421445

Malaysia:

columns:columns: customerID, Date, Amountspent

customerID for Malaysia has a unique prefix 'MY' so it would look like this, MY879745

 

I am required to have data visualization for both within countries and across countries. 

 

so I need to have a script like this:

Script section A(to load all files AUTOMATICALLY)

if Vcountry='MY'    (Malaysia)

run script B which changes some of the fields and renames everything to MY.field

if Vcountry='India' 

run script B which changes some of the fields and renames everything to India.field

 

I also don't want to manually copy-paste script B for all the different countries, is there any way to make it repeat automatically?

 

However I have no idea how to go about doing this, any help would be much appreciated! thank you

0 Replies
Community Browser