topic Re: New field base on fields from 2 different table in QlikView

New field base on fields from 2 different table

Mon, 27 Mar 2017 06:05:33 GMT

TableA:

LOAD

[COUNTRY NAME]

FROM

somewhere

TableB:

LOAD

[Product Number]

FROM

somewhere else

I have 2 tables as shown above. COUNTRY NAME contains countries like USA, England, Indonesia etc. Product Number contains product numbers like 1,2,3,4,5 etc

I want to create a new TableC as shown below.

TableC:

IF([COUNTRY NAME] = 'USA' AND [Product Number] = '1', 'High quality goods') AS [Quality of Goods]

How can I use the fields from TableA and TableB to do my expression in TableC? I am doing all these in the qlikview editor. Thank you

Re: New field base on fields from 2 different table

Anil_Babu_Samineni — Mon, 27 Mar 2017 06:22:35 GMT

May be this?

TableA:

LOAD

[COUNTRY NAME]

FROM

somewhere;

TableB:

LOAD

[Product Number]

FROM

somewhere else;

TableC:

Noconcatenate

Left Join(TableA)

LOAD [COUNTRY NAME],

[Product Number]

IF([COUNTRY NAME] = 'USA' AND [Product Number] = '1', 'High quality goods') AS [Quality of Goods]

Resident TableB;

Drop Tables TableA, TableB;

Re: New field base on fields from 2 different table

Mon, 27 Mar 2017 06:48:32 GMT

It gives me an error "Field not found". The field which is not found is the [COUNTRY NAME]

Re: New field base on fields from 2 different table

MindaugasBacius — Mon, 27 Mar 2017 07:49:10 GMT

What is the key field to TableA and TableB?

Re: New field base on fields from 2 different table

Anonymous — Mon, 27 Mar 2017 09:22:38 GMT

Hi Anil,

I have attached qvw ,PFA.

Thanks

Paridhi