Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate

Hi everyone!

Could you, please, clarify few moments concerting 'concatenate' function.

1) When we're speaking about same fields number and same fields' names, we imply fields that we load in qvd despite ones that original .xls file contains. Is that correct?

2) When we use fields' names recoding in script, qlick view identifies such fields as different or the same?

Example:

Table A:

Load

var1

var2

from ...;

Load

var1

var2 as sales

from ...;

In this case will these tables be concatenated or not?

Many thanks in advance!

Marina

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

If number of Fields and Name are same then AutoConcatenate

Otherwise not... In your second case it will not.

View solution in original post

8 Replies
MK_QSL
MVP
MVP

If number of Fields and Name are same then AutoConcatenate

Otherwise not... In your second case it will not.

Ralf-Narfeldt
Employee
Employee

2. They will not be concatenated.

manojkulkarni
Partner - Specialist II
Partner - Specialist II

It will not get concatenated. Infact it will create a synthetic table on fields common between 2 tables

Not applicable
Author

Manish, great, thanks!

But I didn't not completely understand in which case tables AutoConcatenate:

1) when number of Fields and Name are same in xls file which I load in QVD ?

2) when number of Fields and Name are same in LOAD-function in script ?

3) or in both cases?

MK_QSL
MVP
MVP

Can you explain this?

when number of Fields and Name are same in xls file which I load in QVD ?


Autoconcatenation will happens at script level...


T1:

Load A, B From Table1;

T2:

Load A, B From Table2;


Store T1 into T1.qvd (QVD);


Here even though you are saving only T2 in QVD, data from both table will be stored as T1.qvd because both T1 and T2 is having same number of fields with same name so autoconcatenation happened.

Not applicable
Author

Manish,

I meant this:

***

Table A:

Load

var1

var2

FROM

C:data\Sales_01.xls

Table B:

Load

var1

var2

FROM

C:data\Sales_02.xls

***

Here are two fields and they have same names. It is Ok.

But in this files it looks like that:

Table A:

A.png

Table B:

B.png

Despite that in excel files there are different sets if fields, they will be autoconcatenated?

So sorry for these questions.

MK_QSL
MVP
MVP

If you load only Var1 and Var2 from both File : answer is YES

but if you load full set of fields and data : Answer is NO

Not applicable
Author

Matish, great! Thanks muchly!