Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

demlet123
New 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
MVP
MVP

Re: Automatic Concatenate Not Working

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;

5 Replies

Re: Automatic Concatenate Not Working

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.

wassim1988
New Contributor III

Re: Automatic Concatenate Not Working

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

demlet123
New Contributor III

Re: Automatic Concatenate Not Working

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.

MVP
MVP

Re: Automatic Concatenate Not Working

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

Re: Automatic Concatenate Not Working

Hi,

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

Community Browser