Discussion Board for collaboration on QlikView Scripting.
I have simple example to solve my real problem.
In firtst load source i have three fields:
I need that every date from second soruce will be connected with every Nomenclature and every WareHouse (of cource, without dublicated dates, if some of them match in first source.
My necessary table:
Go to Solution.
(ooxml, embedded labels, table is Source1);
LOAD Date as Date1
(ooxml, embedded labels, table is Source2);
Date1 as Date
DROP Table Main;
(ooxml, embedded labels, table is Source1)
NoConcatenate load Distinct
Concatenate (Main) LOAD * Resident Tmp;
DROP Table Tmp;
I see some other result in your model:
Your excel was pulling in more than 3 rows from source1 tab. try with the attached excel
Not a problem