Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two dimension tables say dim_a and dim_b. dim_a is columns like
dim_a
a1,
a2,
a3,
a4
.
.
.
dim_b
a1,
a2,
b1,
b2,
.
My requirement is I need merge these as a single table. I am done with
dim_a
a1,
a2,
a3,
a4
.
.
.
concatenate(dim_a)
LOAD dim_b
a1,
a2,
b1,
b2,
.
I am able to merge these two tables as single but the problem is here I am able to see only dim_a table data but I am not able to see data from dim_b.
Pls help me out on this issue.
Regards,
KUmar
single table single column or single table with 2 columns, one for each dimension?
LOAD * iNLINE [
dim_a
a1,
a2,
a3,
a4
];
CONCATENATE
LOAD * Inline [
dim_b
a1,
a2,
b1,
b2
]
if names of dimensions are equal(i.e dim_a and dim_b), it creates resultant table with one column
else it creates resultant table with two columns dim_a and dim_b.
Hi
Can you please share a screenshot of the result you want.
Hi,
USe outer join
Try by writing join instead of Concatenate
Regards
Hi,
Do you want output like this?
Hi,
I have to merge into single table with same keys what are common in both tables and rest of all columns from the both tables should be displayed in single table.
Regards,
Kumar
Hi,
Have try it with join.
Regards