topic Re: concat, concatenate, join, key don't match in App Development

concat, concatenate, join, key don't match

Billy_u — Sat, 16 Nov 2024 18:39:06 GMT

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

Re: concat, concatenate, join, key don't match

avkeep01 — Wed, 13 May 2020 13:42:04 GMT

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);

Re: concat, concatenate, join, key don't match

Billy_u — Thu, 14 May 2020 07:56:09 GMT

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!