Discussion Board for collaboration on QlikView Scripting.
I have two dimension tables say dim_a and dim_b. dim_a is columns like
My requirement is I need merge these as a single table. I am done with
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.
single table single column or single table with 2 columns, one for each dimension?
LOAD * iNLINE [
LOAD * Inline [
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.
Can you please share a screenshot of the result you want.
USe outer join
Try by writing join instead of Concatenate
Do you want output like this?
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.
Have try it with join.