Load data from Dynamic Path

[Prabhu1204]

Hello,

Happy New year !!

Please let me know if the below things is possible and how in Qliksense.

I have the below excel for fetching data from different path. Each country have around 10 excel files.

How to dynamically changes the path and fetch the files.

[Anil_Babu_Samineni]

But I am not finding any excel path in second column?

[Prabhu1204]

@Anil_Babu_Samineni 

Basically the excel will be from share point.. and i was given an example one

Is It possible

[Anil_Babu_Samineni]

You meant to say the path for each country is sharepoint? 

[Prabhu1204]

Exaclty

[Anil_Babu_Samineni · Accepted solution]

Try like this..

Table:
Load Country, Path From Table;

LET a = NoOfRows('Table');

For i=0 to $(a)

Let vPath = Peek('Path', $(i), 'Table');
Load * From $(vPath) (ooxml, embedded labels, table is ALL);
Next i;