topic Automatic Concatenate Not Working in App Development

Automatic Concatenate Not Working

Demlet — Tue, 19 Dec 2017 17:17:52 GMT

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

Re: Automatic Concatenate Not Working

Anonymous — Tue, 19 Dec 2017 17:24:46 GMT

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.

Re: Automatic Concatenate Not Working

Anonymous — Tue, 19 Dec 2017 17:29:26 GMT

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

Re: Automatic Concatenate Not Working

Demlet — Tue, 19 Dec 2017 17:33:02 GMT

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.

Re: Automatic Concatenate Not Working

maxgro — Tue, 19 Dec 2017 18:01:05 GMT

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

load * inline [

fielda

];

join ( x)

load * inline [

fieldb

];

tmp:

load * inline [

fielda

];

join (tmp)

load * inline [

fieldb

];

concatenate ( x) load * Resident tmp;

drop table tmp;

Re: Automatic Concatenate Not Working

t_chetirbok — Tue, 19 Dec 2017 19:07:10 GMT

Hi,

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