Correcting mismatched entries with that of a master file

[Bryth]

Hello community, I need help with a workflow i am building. I have a master file which contains the correct match of Names and their market. I then have the main file which contains the wrong match of names and market. I have created the flow and joined the master file and the main file. I want a logic that will correct the right names in the main file against its  right market using the master file which is updated weekly. My formulae seems to always create the correction but also gives null values to some of the enties. can someone assist me with a logic for this use case? 

[binuacs]

@Bryth When you join the Main file with the Master file, you will get the matching records from the Master file, again what formula you are using to correct these Master.Name and Master.Market?

[Bryth]

Hello Binuacs Yes. I get the matching records but the problem is that I get some of the blank records too. Since the number of records coming from the master file and joining it to the main file is not the same. How do i correct that. the formulae I am using is this. @binuacs 

IF [Match]="N" AND [Market]!=[Master_Market] THEN [Master_Market]
ELSEIF [match]="N" AND [Market]=[Master_Market] THEN [Market]
ELSEIF [match]="Y" AND [Market]!=[Master_Market] THEN [Market]
ELSEIF [match]="Y" AND [Market]= [Master_Market] THEN [Market]
ElSEIF [Market]= "Blank" THEN [Market]
Else [Market]
ENDIF

[binuacs]

@Bryth I assume [Match] = 'N' records are from the Left output anchor from your join tool (Records only from the Main file), Are you unioning the J and L anchor and then applying the formula? Trying to understand the logic here. I am attaching a sample workflow for your reference. 

[Bryth]

Hello @binuacs yes I have created a match field which looks at the row level Market from the main dat and the market from the master file and compare them to see if they are a match. if  it is not a match, it will output a "N" and if it is a match it will output a "Y". That is the logic i am working with. But the issue is that the master file market filed  actually gives me the right combination except that there are a lot of blanks in it. 

[binuacs]

@Bryth Can you provide a sample input file and expected output file, so that we can work on your use case? Maybe you can update the workflow I sent you.

[Bryth]

Hello @binuacs  Please find attached a sample input text file.  I have explained the master file and the training file and what it needs to do in the annotation 

[binuacs]

@Bryth When I joined the two data set with FMR Name I got the below result, what will be the next step you followed

Please note: I removed the null rows from both the dataset