topic concatenate not working in App Development

concatenate not working

random_user_3869 — Mon, 18 Apr 2022 09:07:41 GMT

Hello everyone,

I'm doing the following concatenante:

FAIT:
Load DISTINCT
if(len(TEXT([IDENTIFIANT CLIENT DTM])) >0,TEXT([IDENTIFIANT CLIENT DTM])) AS [IDENTIFIANT CLIENT DTM],
[IDENTIFIANT CLIENT DTM] as [IDENTIFIANT CLIENT DTM ORIGINE],
[%LK_DATAMART_CLI],
[IDENTIFIANT TYPOLOGIE MARCHE]

Resident '$(vs_QVD_Prefixe_Niv2)_FAIT_CLIENT'
WHERE [IDENTIFIANT CLIENT DTM] = 'ORION-1227554';
Drop Table '$(vs_QVD_Prefixe_Niv2)_FAIT_CLIENT';

Concatenate(FAIT)
Load DISTINCT
if(len(TEXT([IDENTIFIANT CLIENT DTM])) >0,TEXT([IDENTIFIANT CLIENT DTM])) AS [IDENTIFIANT CLIENT DTM],
[IDENTIFIANT CLIENT DTM] AS [IDENTIFIANT CLIENT DTM LIGNE COMMANDE],
[%LK_DATAMART_CLI_ENTT_LIGN_CDE],
[IDENTIFIANT COMMANDE]
Resident '$(vs_QVD_Prefixe_Niv2)_FAIT_LIGNE_COMMANDE'
WHERE [IDENTIFIANT CLIENT DTM] = 'ORION-1227554';
Drop Table '$(vs_QVD_Prefixe_Niv2)_FAIT_LIGNE_COMMANDE';

But as a resut i get this :

Which i dion't understand.

Please can someone help met.

Thank you

Re: concatenate not working

vchuprina — Mon, 18 Apr 2022 09:24:25 GMT

Hi,

Qlik doesn't work as SQL, for qlik is important to have similar column names in tables.

You just need to change names in the second table.

Regards,

Vitalii

Re: concatenate not working

vchuprina — Mon, 18 Apr 2022 09:35:35 GMT

Concatenate in Qlikview isn't equal to Union in SQL.

There are two main differences:

1. SQL combines columns based on their order. You just need to have the same data type.

Qlik combines columns based on their names, data type doesn't matter.

2. Union in SQL removes duplicates

Concatenate operation in Qlik doesn't remove duplicates, from this point of view it's similar to UNION ALL

Also, please note that Qlik automatically concatenates tables when they have a similar structure, even without CONCATENATE key word

Regards,

Vitalii

Re: concatenate not working

random_user_3869 — Mon, 18 Apr 2022 09:38:16 GMT

hello,

i'm nott sure you understand: basicalle what i want to do is:

fact:

load

field a,

field b

resident table x;

concatenate (fact)

load

field a,

field e

resident table y;

and basically when i do concatenate the key field (field a) do not match even if they are suppose to match (text format and same value)

Re: concatenate not working

vchuprina — Mon, 18 Apr 2022 09:47:16 GMT

Concatenate works as expected, I guess you need to use outer join instead concatenate

Concatenate:

Outer join:

Outer join(table1)

Regards,

Vitalii