How to auto-rerun script for different files?

meera__ — Sun, 13 Jun 2021 13:22:07 GMT

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

topic How to auto-rerun script for different files? in Search the Community