USING IF IN MAPPING DATA FLOWS

Question

Hi! @MarkKromer-MSFT (or anyone who can answer this :-)

I am running out of time so I hope you don't mind another Mapping Data Flow question. I have been working on this but no solution. I have the following data, Native, Naturalized, etc shown below. They have to be mapped to my ADF Mapping Data Flow Output csv document so that 1 shows for Native, 2 for Naturalized and so on. How can I do this with Data Flows? I tried if but it didn't work.

1--> Native
2--> Naturalized
3--> Alien Permanent
4--> Alien Temporary
5--> Alien
N-->Not Indicated

Thanks!
Mike Kiser

Answer 1

Are you trying to map the strings (Native, Naturalized ...) to an enum value (1,2,...)?

If so, how about a case statement? https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions#case

i.e.

case (
column == 'Native', 1,
column == 'Naturalize', 2,
.
.
.
)