account mapping using an existing field

[jennajin689]

Hi alteryx community,

I am trying to map account abc_10t (row 13) using the mapping for account abc_10 (row 1). Please see the simplified mapping file below. Right now abc_10t has mapping in it and it is the wrong mapping. The mapping 1-4 files for abc-10t should be the same as abc-10. I want to keep the account number abc-10t as it is but to update the mapping columns D-G. How can I do it? Thanks!

[TrevorS]

Hello @jennajin689,
Thanks for reaching out to the Community!

To help our Community members better troubleshoot your workflow issues, can you please provide the following:

* What Alteryx Version are you using?
* Do you have a Workflow you can share?
* What about a Screenshot?
* What does the data look like? (Beginning data vs. Final Output)

Posting for Fastest Possible Solution (https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/t...)

Thank you very much!

[ArtApa]

Hi @jennajin689 - I wanted to make the workflow Dynamic. That's why I introduced a Text Input tool for you to be able to manually define From/To accounts. Hope this makes sense and will work for you: