CERTAIN FIELDS ARE NOT MATCHING IN ALTERYX IN JOIN TOOL

draghava

i am trying to match the fields in alteryx but certain fields are not matching . I have attached the input and workflow please advise the reason . 

GL223.xlsx

Unreconciled.xlsx

danilang

hi @chinu267 

The reason you're getting 13 unmatched records is that in GL233.xlsx missing Locations are represented as [Null].  In Unreconciled.xlsx, missing locations show up as "" (blank strings) and according to Alteryx [Null] does not match ""

Add a formula tool between Unreconciled.xlsx and your join to convert [Location] to [Null] like this

if isempty([Location]) then
	null()
else
	[Location]
endif

Or add a Data Cleansing tool after GL233 to convert all [Null] values to Blanks.

Dan