Copying Data to Blank Rows

[NBPSE]

I have an instance where there is missing data in some of my rows. In the attached example, I need the Number 2 Column Puppy and Cat rows that do not have an address to find the highest Number 3 number row that has address data and copy the Address, City and Zip code column data to the rows that do not have an address. The blank Puppy row would use the 4321 Address, and the Cat blank row would use the 543 Address.

[binuacs]

@NBPSE can you provide the expected output?

[abacon]

@NBPSE Based on your description, I believe this is what you are looking for. I found the address of the max number 3 column grouped on the required columns and then joined it back to the data to append the address information.

Bacon

[Gaurav_Dhama_]

First, we will find the max Number 3 for each description.

Second, we find the address for the result for First step.

Once we have the address for all the groups with Max Number 3, lets join for the Description where there is no address.

Then get all the data back together, sort it for record ID which I added in beginning for the same reason.

Attached is the workflow for the same.

[NBPSE]

Unfortunately neither of these solutions are working. The first is duplicating rows, and the second seems to be pulling in data rows twice and therefore doubling the total output.

[abacon]

@NBPSE Please post the desired output, based on your description it is very difficult to know what you are looking for.

Bacon

[Gaurav_Dhama_]

Is the duplication happening with your original data? Because if that is the case then there might be something that is missing in the sample inputs, can you add the condition where you are getting duplicates.

[NBPSE]

Yes, here is the expected output. Address carried over to Number 2's missing Addresses based on largest Number 3 with an Address. There are no duplicates in the original data.

[Gaurav_Dhama_]

Ok so in the solution that i posted, you just need to pick the right columns for values that you need to replace from blank, and remove any other unnecessary columns .

Check the join configuration, currently it is set for address only, you can add zip and country as well in same fashion.