Preceding Load from 2 different Tables or how to calculate?

[#1]

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

[robert99 · Accepted solution]

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

[#3]

Wow .... i will try this!

But what does 'NoLU' in ApplyMap mean?

[robert99]

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