Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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!