topic Re: Load data from Dynamic Path in App Development

Load data from Dynamic Path

Prabhu1204 — Tue, 21 Dec 2021 20:02:52 GMT

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 — Mon, 04 Jan 2021 09:18:08 GMT

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

Prabhu1204 — Mon, 04 Jan 2021 11:44:02 GMT

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

Is It possible

Anil_Babu_Samineni — Mon, 04 Jan 2021 13:04:50 GMT

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

Prabhu1204 — Mon, 04 Jan 2021 13:10:15 GMT

Exaclty

Anil_Babu_Samineni — Mon, 04 Jan 2021 16:13:27 GMT

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;