Join Tool

[Alwin21]

I am joining two inputs using join tool .  the 1st input has 6357 records and the second  has18 records.

18 records were joined. but on the left anchor it is showing a lot of null rows.. im planning to join/union again the J and L anchor but because of those null rows it is causing trouble in the workflow. I am also  sharing screenshot of my workflow. Thanks for the help

 

[Luke_C]

Hi @Alwin21 

If these are excel files the used range of the workbook is probably bigger than the data itself. You can simply add a filter tool and filter out the null records.