topic Re: Copying Data to Blank Rows in Alteryx Designer Desktop Discussions

Copying Data to Blank Rows

NBPSE — Mon, 04 Aug 2025 14:21:07 GMT

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.

Re: Copying Data to Blank Rows

binu_acs — Mon, 04 Aug 2025 14:53:07 GMT

@NBPSE can you provide the expected output?

Re: Copying Data to Blank Rows

abacon — Mon, 04 Aug 2025 14:53:57 GMT

@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

Re: Copying Data to Blank Rows

Gaurav_Dhama_ — Mon, 04 Aug 2025 14:57:00 GMT

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.

Re: Copying Data to Blank Rows

NBPSE — Mon, 04 Aug 2025 15:44:19 GMT

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.

Re: Copying Data to Blank Rows

abacon — Mon, 04 Aug 2025 15:48:00 GMT

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

Bacon

Re: Copying Data to Blank Rows

Gaurav_Dhama_ — Mon, 04 Aug 2025 16:10:38 GMT

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.

Re: Copying Data to Blank Rows

NBPSE — Mon, 04 Aug 2025 16:24:41 GMT

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.

Re: Copying Data to Blank Rows

Gaurav_Dhama_ — Mon, 04 Aug 2025 18:48:10 GMT

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.