Find Replacing specific cells in table and Looping through multiple iterations

terrence10

Hello,

I am trying to rename a specific cell in my semi-unformatted dataset:

I want to edit the 4 Placeholder values in this data. The way I currently have it setup is to use 4 Find/Replace tools:

Using a Rename Grid like this: - 

And then output the file with the renamed values

Had two questions from this:

1. Is there a way I can have Alteryx target a specific cell (e.g. change Cell B4 "Placeholder1" --> "Blue" -- instead of the Find replace tool that looks at column F2 / F6

           This would avoid the case where there are multiple "Placeholder1" values in column F2. I only want Alteryx to change cell Placeholder1 in cell B4.

2. Is there a way to iterate this workflow, so if I add a second row to my Rename grid -- two output files will be produced, with the two different sets of renamed Placeholder values? Want to eventually add 6 entries in my Rename grid

Workflow and input dataset attached.

Thank you!

Input File for Renaming.xlsx

Metadata Rename.yxwz

Qiu

@terrence10 
If you want to specify the Cell for naming update, it is reasone to assume that we can provide the Cell information in your Name Grid. 

I always use the Combination of Transpose and Cross Tab if we have to deal multiple columns.

A quick sample attached here for single batch and multiple Batch, hope it will help.

Metadata Rename.yxzp