Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
But I am not finding any excel path in second column?
Basically the excel will be from share point.. and i was given an example one
Is It possible
You meant to say the path for each country is sharepoint?
Exaclty
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;