Joining & Unioning in 1 tool

[MarqueeCrew]

The JOIN tool could use some love.  Let's consider merging the JOIN and UNION functions into a single tool.  Instead of strictly L, J, and R outputs, we could have an option to allow for all standard SQL joins:

• Cross Join (Warning!!!)
• Inner Join (boring)
• Left Outer Join (saves time configuring Union)
• Right Outer Join (saves time ...)
• Full Outer Join (saves time ...)

Being able to JOIN on case-insensitive values is a big bonus (resisted urge to BOLD and change font size).

Being able to JOIN on date-range is often requested.

Being able to JOIN on numeric-range is often requested.

If we are combining tools, getting UNIQUE on L or R (or both) inputs would also save time.  Most JOIN errors are because the incoming (R) data contains duplicates by KEY.

cheers,

Mark

Hi @NicoleJ 

[Thableaus]

If we have case-insensitive match in the Find & Replace tool, we should also have the same exact checkbox for the Join Tool! Why not?

[TheOC]

I like the separate tools for similar reasons to @simonaubert_bd . However, this would be cool as a new tool (Unioned Join, etc). I can definitely see the use-case and time save.

[ianjohnston]

@MarqueeCrew 

Hi Mark

Would definitely love to have the functions from the JOIN and UNION tools working as one.

Have often thought about having two tools set up in this kind of format:

• OUTER JOIN - Left Outer Join + Right Outer Join + Outer Join + Full Outer Join
• INNER JOIN - Left Join + Right Join + Inner Join 

[hetherp]

Would be also great if the join tool allowed you to 'Join by All Fields' as well as Join by Record Position and Join by Specific Fields.