New field base on fields from 2 different table

[#1]

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

[Anil_Babu_Samineni]

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;

[#3]

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

[MindaugasBacius]

What is the key field to TableA and TableB?

[Anonymous]

Hi Anil,

I have attached qvw ,PFA.

Thanks

Paridhi