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

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.

helpwithAlt.JPG

Join

Accepted answers

davidskaife

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.

Example.yxmd

All comments

davidskaife

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.

Example.yxmd

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.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335