Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
i am new to qlikiew and i am using Preceding Load the first time.
I have 2 Excel Files:
File1:
A
B
C (i.e. C = D - F)
D
File2:
E
F
G
In the Load Script i am loading all data from File1, but i also need the column F from file2 to calculate values for column C in file1.
Is there a possibility to solve the problem?
Thanks and best regards,
Sabrina
Something like this to use applymap
Qlik3:
LOAD Start_Datum as Datum,
Status,
Art,
Verkauft,
Verfügbar,
Preis,
Besucher,
Umsatz,
Hersteller,
Artikelnummer,
Titel
FROM
(ooxml, embedded labels, table is Qlik_3);
Qlik3Map:
mapping load
Datum,
Umsatz
resident Qlik3;
LOAD Plattform,
PlattformVJ,
Datum,
[Artikel Online],
[Umsatz in € gesamt] - applymap ('Qlik3Map',Datum, 'NoLU') as [Umsatz in €],
[Verkaufte Artikel],
Deals_Liste,
[Umsatz in € gesamt],
DDMM
FROM
(ooxml, embedded labels, table is Qlik_2.de);
instead of 'NoLU' you could use null() or say 1 or 0 etc. This is the default if a lookup is not found
Wow .... i will try this!
But what does 'NoLU' in ApplyMap mean?
instead of 'NoLU' you could use null() or say 1 or 0 etc. This is the default if a lookup is not found
And I hope it works. I'm not the greatest with script but think I have got this right