Joint tool issue - total input doesn't match output (when couting L,R,J)

Question

Hi All,

Having issues with the Joint tool and missing 144 rows when using union tool on the outputs J, L, R. Please see screenshots attached for the exact numbers on the inputs vs outputs on the JOINT tool.

Using two fields on the joint tool, checked select tool and data types for the two fields are the same.

Output J.PNG

Input L.PNG

Output R.PNG

Input R.PNG

Output L.PNG

alexnajm · Answer

If there is 32580 coming in from the Left input, then this should equal the addition of the L and the J outputs (which it does). 32413 out of the L output and 167 out of the J equals the original 32580. So this behavior is fine to me.

Similarly, 1286 coming in from the Right input, 1142 coming from the R output and 167 out of the J. this means 1309 total records from both the R and the J - this means you have duplicate keys showing up. Please check your data!

I am not seeing the same 144 records missing from these screenshots, but maybe it's because you aren't utilizing Browse tools to view all the data?

Qiu · Answer

@camilatoyonaga 
Thats is a bit strange.
maybe you can put a Count record tool after L, J, R anchors to count?

Is it possible for you to share the flow including the input data?