topic Re: Concatenate two resident tables in QlikView

Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 18:47:04 GMT

I need to concatentate these tables.. Right now its simply droping the DCR_Solutions and leaving a Synthetic table.

I'm sure its a simple issue at play here.

All_Solutions:
LOAD *
Resident DCR_Solutions;

Concatenate //(All_Solutions)

LOAD *
Resident Materiel_Solutions;

Drop Tables DCR_Solutions;

Re: Concatenate two resident tables

jagan — Mon, 22 Jul 2013 18:55:44 GMT

Hi,

Try this

All_Solutions:
LOAD *
Resident DCR_Solutions;

Concatenate //(All_Solutions)

LOAD *
Resident Materiel_Solutions;

Drop Tables DCR_Solutions, Materiel_Solutions;

Regards,

Jagn.

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 18:57:09 GMT

Hi,

Use NoConcatenate before the all solution tables load script.

Qlikview automatically concatenates the tables with same structure.

Try with this.

NoConcatenate

All_Solutions:
LOAD *
Resident DCR_Solutions;

Concatenate //(All_Solutions)

LOAD *
Resident Materiel_Solutions;

Drop Tables DCR_Solutions;

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:05:26 GMT

this method leaves no tables behind. happened to me as well.

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:06:05 GMT

Freezes up, not sure why. I understand what your saying though.

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 19:10:58 GMT

I hope you have to drop Materiel_Solutions also.

Can you post you qvw or load script?

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:19:23 GMT

I wish I could, its Customer data. Essentially its to Excel Worksheets that have a lot of commom fields 30 or so in each both were converted from Crosstables.

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:24:21 GMT

Dropped both using script above still leaves below in place..

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 19:32:26 GMT

Hi,

Looks like you have not concatenated

Materiel_Solutions .

Could you post the script?

or are you using the script like below?

NoConcatenate

All_Solutions:
LOAD *
Resident DCR_Solutions;

Concatenate(All_Solutions)

LOAD *
Resident Materiel_Solutions;

Drop Tables DCR_Solutions,Materiel_Solutions;

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 19:33:58 GMT

No. Dont provide customer sensitive information right here. Just scramble the qlikview file data and post it here. Just to check your script.

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 19:39:38 GMT

Hi,

You have used EXIT Script in the combine tab is this you done it for testing? Could you please check it?

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:41:55 GMT

it was. after reload the data is gone from drop statements. I placed to make sure it didnt get erased.

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 19:44:18 GMT

Check with this script.

T2:

NoConcatenate

LOAD *

Resident DCR_Solutions;

Concatenate(T2)

LOAD *

Resident Materiel_Solutions;

Drop Tables Materiel_Solutions, DCR_Solutions;

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:49:47 GMT

It worked! I guess I needed to place NoConcatenate etc for it to work ?

Re: Concatenate two resident tables

b_garside — Mon, 22 Jul 2013 19:53:07 GMT

Ok so it was concatenating from the tables in the previous tabs.

Re: Concatenate two resident tables

CELAMBARASAN — Mon, 22 Jul 2013 20:03:32 GMT

Yes absolutely.