Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kumarreddy257
Contributor

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
Honored Contributor II

Re: Concatenate load problem

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

qlikmsg4u
Valued Contributor

Re: Concatenate load problem

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
Contributor II

Re: Concatenate load problem

Hi

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

Re: Concatenate load problem

Hi,

USe outer join

Try by writing join instead of Concatenate

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Concatenate load problem

Hi,

Do you want output like this?

kumarreddy257
Contributor

Re: Concatenate load problem

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

Re: Concatenate load problem

Hi,

Have try it with join.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser