How do I replace empty cells with correct information from another input

[CherieACI]

I have data in one input that has some missing customer numbers. I have another input that I'm joining to it for additional information but it also contains the customer number. How do I get the customer numbers from the 2nd input to replace the missing ones in the first input? I thought the union tool would take care of this but they are still blank in the output. 

Input #1

Input #2

When they go through the join tool and then the union tool why doesn't the customer # get populated on all lines if they are present in the 2nd input?

Thank you!

[T_Willins]

Hi @CherieACI,

The Union tool alone will not fill in the missing data.  The Union Tool stacks all the inputs on top of each other.  There are a few ways to fill in the missing data.  Since I can't see the details in your  workflow, is the "Rc Linc Customer Name" field getting unioned in the same field as Customer?  If yes, then add a sort tool after the Union tool and sort by Customer Name ascending and Customer Number descending.  Then add a Multi-Row Formula tool, select field Customer Number and not creating a new field.  Group on Customer.  The formula will be:  IF IsEmpty([Customer Number]) THEN [Row-1:Customer Number] ELSE [Customer Number] ENDIF.

Let me know if this works or doesn't fit your workflow.  

Happy Alteryxing!

[CherieACI]

I haven't used that multi-row formula tool before and couldn't get the formula in there but what I ended up doing was uncheck the customer # from the first input and selected it only in the 2nd input and that solved it! Thank you for your response, I will have to mess around with that multi-row formula tool! 

Cherie

[T_Willins]

Hi @CherieACI,

Glad you got it to work.  There are several examples on the Community of using the Multi-Row formula to fill in missing data, but I would recommend starting with the Interactive lesson here:  https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872