Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need your help about a development problem.
I have an Excel that is regulary updated. It is composed of a supplier name, and several site.
Each supplier may be present for one or several sites, with a different code (I join you an Excel file for a better understand).
Do you know how can I aggregate all codes behind the supplier name, to automatically get back corresponding data from the several sites ?
I hope I am clear...
Thanks lot for your help
see Crosstable load in help file
use cross table
DATA:
CrossTable(Site, Data)
LOAD Supplier,
[Site A],
[Site B],
[Site C],
[Site D]
FROM
[qlik-suppliers (1).xlsx]
(ooxml, embedded labels, table is Feuil1);