Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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