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.
b_garside
Valued Contributor

Concatenate two resident tables

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;

1 Solution

Accepted Solutions

Re: Concatenate two resident tables

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;

15 Replies
MVP
MVP

Re: Concatenate two resident tables

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

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

Re: Concatenate two resident tables

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

b_garside
Valued Contributor

Re: Concatenate two resident tables

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

Re: Concatenate two resident tables

I hope you have to drop Materiel_Solutions also.

Can you post you qvw or load script?

b_garside
Valued Contributor

Re: Concatenate two resident tables

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

Re: Concatenate two resident tables

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

2013-07-22_152150.png

Re: Concatenate two resident tables

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

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

Community Browser