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: 
Demlet
Contributor III
Contributor III

Automatic Concatenate Not Working

Why wont these tables auto-concatenate? For example Closed_By1 should concatenate with Closed_By2.

QlikSense Auto Concatenate Criteria --

"If the field names and the number of fields of two or more loaded tables are exactly the same, Qlik Sense will automatically concatenate the content of the different statements into one table."


Capture.PNG

UPDATE 12/19/2017:


I also needed to turn on "Custom" in my REST Connection settings. This was creating a new set of __Key_results each pagination loop...

-Derek

Message was edited by: Derek Emlet

1 Solution

Accepted Solutions
maxgro
MVP
MVP

If I understand you can use a temporary table for the second join and then concatenate

x:

load * inline [

fielda

1

2

];

join (  x)

load * inline [

fieldb

3

4

];

tmp:

load * inline [

fielda

11

22

];

join (tmp)

load * inline [

fieldb

33

44

];

concatenate ( x) load * Resident tmp;

drop table tmp;

View solution in original post

5 Replies
Anonymous
Not applicable

Don't know, but I usually force concatenation in the script rather than rely on auto concatenation as it makes the script more obvious when being looked at.

Maybe a forced concatenation will sort you.

Anonymous
Not applicable

Hi Derek, remove the table labels for the seconds tables.

Demlet
Contributor III
Contributor III
Author

Thanks for reply,

Do you know if there is a way to force concatenate AFTER the Load statements?  I am doing an INNER Join between two tables, so if I concatenate the one table before the INNER JOIN, it wont work correctly.

For Example in my script I'm mapping the Username to the Resolved_byID for this one load.


SQL WITH CONNECT

//data//


[Resolved_By1]:

LOAD

sys_id AS resolved_by_id,

name AS Resolved_By

RESIDENT SU.RestConnectorMasterTable;

[resolved_by1]:

Inner JOIN (Resolved_By1)

LOAD

[value] AS [resolved_by_id],

[__FK_resolved_by] AS [INC.__KEY_result]

RESIDENT INC.RestConnectorMasterTable

WHERE NOT IsNull([__FK_resolved_by]);

///more load statements here// then another

SQL WITH CONNECT

[Resolved_By2]:

LOAD

sys_id AS resolved_by_id,

name AS Resolved_By

RESIDENT SU.RestConnectorMasterTable;

[resolved_by2]:

Inner JOIN (Resolved_By2)

LOAD

[value] AS [resolved_by_id],

[__FK_resolved_by] AS [INC.__KEY_result]

RESIDENT INC.RestConnectorMasterTable

WHERE NOT IsNull([__FK_resolved_by]);

Thanks for the help.

maxgro
MVP
MVP

If I understand you can use a temporary table for the second join and then concatenate

x:

load * inline [

fielda

1

2

];

join (  x)

load * inline [

fieldb

3

4

];

tmp:

load * inline [

fielda

11

22

];

join (tmp)

load * inline [

fieldb

33

44

];

concatenate ( x) load * Resident tmp;

drop table tmp;

t_chetirbok
Creator III
Creator III

Hi,

If you write your resolved_by2 load before the first inner join, probably it will work