Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to create a list of distinct values from 3 columns on a sheet the columns are loaded from an excel file, column names are
Pack 1
Pack 2
Pack 3
So I need a new table in the sheet with the distinct values from Pack 1, Pack 2 & Pack 3 (one column with all the distinct values in a separate table).
Is this possible to do at sheet level? Everything I've tried so far has not worked but I'm new to Qlik so I'm sure there is a simple solution.
Thanks
Paul
Hello Paul,
Pack_Tmp:
LOAD
Value
From Pack 1.xlsx;
Concatenate(Pack_Tmp)
LOAD
Value
From Pack 2.xlsx;
Concatenate(Pack_Tmp)
LOAD
Value
From Pack 3.xlsx
NoConcatenate
Pack:
LOAD distinct
Value
Resident Pack_Tmp;
Drop Table Pack_Tmp;
Best regards,
Steven