Copying Data to Blank Rows

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.

Data.xlsx

Designer Cloud

Accepted answers

All comments

binu_acs

@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

Copying Data to Blank Rows.yxmd

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.

Puppy and Cat.yxmd

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.

Expected Output.jpg

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.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703