Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Force concatenate them, like:
FinalTable:
Load
*
From <tab1>;
Concatenate
Load
*
From <tab2>;
Force concatenate them, like:
FinalTable:
Load
*
From <tab1>;
Concatenate
Load
*
From <tab2>;