Field matching

Kushal_Chawda — Mon, 16 Jun 2014 11:30:29 GMT

Dear All,

I stuck at the below requirement, your help will be appreciated.

I have one table with fields

tab1:

load A,

From tab1

I have second table with fields

tab2:

load A,

From tab2

Now if you observed both the table it has common filed A, B.

But in table 2 I want to show C, D,E as blank.

Manually I can do this by loading tab2 as

tab2:

load A,

'' as C,

'' as D,

'' as E

from tab2

But I don't want to do it manually, because I need to check 45 tables with tab1.i.e I need to check which fields are missing from 45 tables which is available in tab1, if it is missing assign it as blank.

Is there any way to automate using loop.

Re: Field matching

tresB — Mon, 16 Jun 2014 11:34:05 GMT

Force concatenate them, like:

FinalTable:

Load

From <tab1>;

Concatenate

Load

From <tab2>;

topic Field matching in QlikView

Field matching

Re: Field matching