Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions
Another Mapping Data Flow Question regarding mapping....
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mike Kiser
1,536
Reputation points
Hi @MarkKromer-MSFT ,
I am almost finished on this app; just one more issue if you don't mind. I worked on this and the other solution late last night.
This is very similar to the other one that you helped me with yesterday except this time I need to read the column next to the column I'm mapping. For example, if the Citizenship column is 1, (which we did yesterday) then the CitizenshipDesc field should read "Native" and so on. The only difference is that now I have to read a column to get the data and then translate.
That should be the translated as below
If Citizenship is 1 then Native etc
1--> Native
2--> Naturalized
3--> Alien Permanent
4--> Alien Temporary
5--> Alien
N-->Not Indicated
Again, I appreciate your help with this and I can meet my deadline.
Thanks again!
Mike Kiser
Azure Data Factory
{count} votes
-
MarkKromer-MSFT 5,226 Reputation points Microsoft Employee Moderator2021-07-28T17:00:27.18+00:00 This looks good ... is there an issue you are encountering?
-
Mike Kiser 1,536 Reputation points
2021-07-28T17:59:38.92+00:00 Hi @MarkKromer-MSFT ,
Yes, Citizenship is a different column than CitizenshipDesr which I am trying to create and am getting all Nulls for it.
Thanks
MIke -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mark Kromer MSFT 1,146 Reputation points2021-07-28T19:03:19.103+00:00 Can you provide a screen capture of what is in the Citizenship column? You can get that by just changing this derived column to just Citizenship and then click data preview.
-
Mike Kiser 1,536 Reputation points
2021-07-28T19:29:33.927+00:00 -
Mike Kiser 1,536 Reputation points
2021-07-28T19:30:15.93+00:00 That did it Mark!!! Thanks again so much!!
Mike
Sign in to comment
Sign in to answer