Hello,
I am using the join tool in a workflow, the scope is to have a left join (with all the records from the left table + the columns from the right table as in SQL).
However I have notice that in outcome I have only the selected rows without the columns from the right table (those fields are grey and no dimension or type is set).
Is it a way to have such result?
Best regards,
Solved! Go to Solution.
Hey @Scardax, to conduct the equivalent of a left join in Alteryx, you need to Union the results of the L and J anchor. At the moment, you're only taking the results of everything which sits in the left table and didn't find any matches within the right table, therefore the right-hand headers weren't brought in. I've attached a little example here for you to look at - hope this helps.
ok, clear.
Thank you.
@Scardax . I would recommend you to go through the join tool documentation in below link.
https://help.alteryx.com/20221/designer/join-tool
They have explained about how to implement left join in Alteryx in detail.
Please let me know if it was helpful.
Thanks.