question

ewinkiser avatar image
0 Votes"
ewinkiser asked ShaikMaheer-MSFT commented

ADF and Mapping Data Flows - Creating a New Column and moving it's order

@nasreen-akter @VaibhavChaudhari @KranthiPakala-MSFT

Another "basic" question on Mapping Data Flows but I can't find the answer googling....

I figured out how to use SELECT and drag column names to reorder; HOWEVER now the data isn't moving along with the column reorder and I am just getting NULLs for the FirstName for example when the Source Has all first names in that column? Please assist!
Thanks!
Mike

116739-screenshot-2021-07-21-105357.jpg

116779-screenshot-2021-07-21-123502.jpg


azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ewinkiser ,

Thank you for posting your query on Microsoft Q&A.

Could you please share your data flow implementation entirely with screenshots step by step? So that we can follow along to reproduce scenario and help on resolution. Thank you.

0 Votes 0 ·

Hi @ewinkiser ,

As requested in above comment, could you please help sharing your implementation step by step? So that we follow along to reproduce issue.

Between, try to restart debug session and see. Thank you.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered ewinkiser commented

Hey Ewin,
Not sure whether this would work but need to try out :
You can open the code aspect of the data flow and try rearranging there.

the code aspect is the {} symbol at the top corner

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @NandanHegde-7720 ! I rearranged the columns but the data didn't go along with them. Any suggestions?
Thanks
Mike

0 Votes 0 ·