Join tool missing columns

[Scardax]

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,

[DataNath · Accepted 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.

[Scardax]

ok, clear. 

Thank you.

[grazitti_sapna · Accepted solution]

@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.

[Scardax]

Thanks.