concatenate not working

[random_user_3869]

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

[vchuprina]

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

[vchuprina]

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

[random_user_3869]

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)

[vchuprina]

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

Concatenate:

Outer join:

Outer join(table1)

Regards,

Vitalii