DATA EQUALIZATION

[ALI4]

Greetings,

I am new on QLIK and I have one task to do.

I have two excel files 

1) POD

2) TAG

In two files one data is common that is (m3) of water.

For suppose: POD=TAG=m3, so what code I have to put to analyze for suppose.

when I analyze m3 with TAG only it gives me same result as when I analyze it with POD. In simple words I want to generate script that equalize TAG and POD to m3.

I am attaching the example of files. Please help me in this regard

Thankyou

[ALI4]

Greetings,

I am new on QLIK and I have one task to do.

I have two excel files 

1) POD

2) TAG

In two files one data is common that is (m3) of water.

For suppose: POD=TAG=m3, so what code I have to put to analyze for suppose.

when I analyze m3 with TAG only it gives me same result as when I analyze it with POD. In simple words I want to generate script that equalize TAG and POD to m3.

I am attaching the example of files. Please help me in this regard

Thankyou

[ogster1974]

looks to me your join key is a composite of m3|date|COMUE so try something like.

Result:

Load

*

FROM TAG

;

JOIN (Result)

LOAD

m3, date, COMUE

TAG AS COD_POD

FROM POD

;