Concatenate two resident tables

[b_garside]

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;

[jagan]

Hi,

Try this

All_Solutions:
LOAD *
Resident DCR_Solutions;

Concatenate //(All_Solutions)

LOAD *
Resident Materiel_Solutions;


Drop Tables  DCR_Solutions, Materiel_Solutions;

Regards,

Jagn.

[CELAMBARASAN · Accepted solution]

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;

[b_garside]

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

[b_garside]

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

[CELAMBARASAN]

I hope you have to drop Materiel_Solutions also.

Can you post you qvw or load script?

[b_garside]

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.

[b_garside]

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

[CELAMBARASAN]

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;

[CELAMBARASAN]

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