Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Concatenate load problem

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

7 Replies
giakoum
Partner - Master II
Partner - Master II

single table single column or single table with 2 columns, one for each dimension?

qlikmsg4u
Specialist
Specialist

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.

prajapatiamar38
Creator II
Creator II

Hi

Can you please share a screenshot of the result you want.

PrashantSangle

Hi,

USe outer join

Try by writing join instead of Concatenate

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Hi,

Do you want output like this?

Anonymous
Not applicable
Author

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

PrashantSangle

Hi,

Have try it with join.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂