Simple question - replace one cell from input 2 with info from input1

[VictoriaBudak]

I am new to Alteryx and spent hours trying different joining tools before reaching out for help on here. 

I need to create a table and use information from 2 inputs. 

Input2 is the template of the report and 1 cell needs to be replaced with the information from Input1 (text in yellow to be replaced with text in blue). 

Can someone please kindly show me an example so I can progress. Thank you so much. 

[DavidSkaife · Accepted solution]

Hi @VictoriaBudak 

Try this, append the data from Input 1 onto Input 2, then use a Formula tool to fill in the answer using IF..ELSE logic, finally use a Select tool to remove any fields not required.

[OTrieger]

@VictoriaBudak 

Why are you input the 2 files?

If you need only to replace the text in that specific cell, you can do it by getting the data and then write it into a specific cell in a specific file.

What are you trying to do in general, to understand why you inputting both files into Alteryx?

[VictoriaBudak]

Hello, 

I need to create a report with one column will be changed based on the manual search option I am going to add. So I need to link that cell somehow to the output. So I thought 1st input - desired columns, second - input I save over.