Automatic Concatenate Not Working

[Demlet]

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."

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

[Anonymous]

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]

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

[Demlet]

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 · Accepted solution]

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]

Hi,

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