concat, concatenate, join, key don't match

[Billy_u]

hello everyone, I have two tables that match with a key, but not 100% and I would like to concatenate where they do not match, to still bring me the value that cuts me .... suggestions?

thanks a lot to everyone

Billy

[avkeep01]

Hi @Billy_u , 

Try using a EXISTS function. For example: 

Table1:
LOAD
[Table1Field] AS Key
FROM Table1; 

Table2:
LEFT JOIN (Table1) LOAD
[Table2Field] AS Key,
'Linked' AS Type
FROM Table2; 

CONCATENATE (Table1) LOAD
[Table2Field] AS [Key],
'Not linked' AS Type
FROM Table2
WHERE NOT EXISTS('Key',Table2Field); 

[Billy_u]

really many thanks, let's say I was on this path, I will analyze your proposal which is perhaps slightly different from mine, thanks, I'll let you know!