Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Replacing values in source file with values from map

Stanislaw
7 - Meteor

Hello everybody,

 

I'm a beginner and I would gladly use your help.

 

So I have 2 files: one is a source file and the other one is a map. I would like to replace values from source file with values from the map.

Unfortunately, I don't know how.

 

Source File:

DateTeaCoffeeMilkBeer
2020M1045126373
2020M1134126072
2020M1246145985

 

Map File:

TeaCODE: 1
CoffeeCODE: 2
Milk

CODE: 3

BeerCODE: 4

 

Expected output

DateCODE: 1CODE: 2CODE: 3CODE: 4
2020M1045126373
2020M1134126072
2020M1246145985

 

Thank you in advance!

2 REPLIES 2
Assaf_m
11 - Bolide

Check attached solution

 

Stanislaw
7 - Meteor

Whoa, it works, thank you!

I've been trying to solve the issue with the "Find Replace" tool.

Turns out, I should have been using "Dynamic Rename" instead.

Labels