topic Re: Concatenate load problem in QlikView

Concatenate load problem

Anonymous — Wed, 10 Jun 2015 06:31:04 GMT

Hi,

I have two dimension tables say dim_a and dim_b. dim_a is columns like

dim_a

a1,

a2,

a3,

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,

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

Re: Concatenate load problem

giakoum — Wed, 10 Jun 2015 06:39:37 GMT

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

Re: Concatenate load problem

qlikmsg4u — Wed, 10 Jun 2015 06:42:24 GMT

LOAD * iNLINE [

dim_a

a1,

a2,

a3,

];

CONCATENATE

LOAD * Inline [

dim_b

a1,

a2,

b1,

]

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.

Re: Concatenate load problem

prajapatiamar38 — Wed, 10 Jun 2015 06:44:41 GMT

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

Re: Concatenate load problem

PrashantSangle — Wed, 10 Jun 2015 06:45:47 GMT

Hi,

USe outer join

Try by writing join instead of Concatenate

Regards

Re: Concatenate load problem

Wed, 10 Jun 2015 06:47:54 GMT

Hi,

Do you want output like this?

Re: Concatenate load problem

Anonymous — Wed, 10 Jun 2015 09:17:36 GMT

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

PrashantSangle — Wed, 10 Jun 2015 09:25:47 GMT

Hi,

Have try it with join.

Regards