Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Fields are missing from join.

markp201
8 - Asteroid

Here is my flow - very simple summarize and a join

Capture.JPG

 

Capture.JPG

 

Left and right join are empty yet some fields are null for the inner join.

How is this possible?

4 REPLIES 4
pcatterson
11 - Bolide

Check your left and right flows with some browses.  There is probably some null values in both places which are matching.

markp201
8 - Asteroid

Thanks for the pointer but found the issue.  I don't why but join sorted the rows which had the ill effect of putting the nulls at the top.

RodL
Alteryx Alumni (Retired)

FYI...When joining on Key Field, Alteryx sorts the records behind the scenes in order to make the join more efficient.

sujithgk
6 - Meteoroid

yes even i got the same issue, but my workflow works with realtime data , so sometimes the data will be NULL, and it has to perform a join operation. But in this case how to handle the issue when my data is NULL . 

Labels