Field matching

[Kushal_Chawda]

Dear All,

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

I have one table with fields

tab1:

load A,

B,

C,

D,

E

From tab1

I have second table with fields

tab2:

load A,

B

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,

B,

'' 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.

[tresB · Accepted solution]

Force concatenate them, like:

FinalTable:

Load

          *

From <tab1>;

Concatenate

Load

          *

From <tab2>;