question

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

Need help in data mapping in ADF - urgent please!

Hi @nasreen-akter @MartinJaffer-MSFT @KranthiPakala-MSFT

I have one table shown below with just 2 columns...

I need to map Row#1 (RecordType15) to a column in another DB Table...Row#2 (RecordType20) to another in the same DB Table etc through Row#5

There are only 5 Record Types ever and each one has a number of Counts related to each Record Type.

I tried using Row[0] in the mapping but that didn't work and I need to get this to QA...

Can someone please help
Thanks!
Mike Kiser

123703-screenshot-2021-08-16-155731.jpg


azure-data-factory
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.

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered HimanshuSinha-MSFT commented

Hello @ewinkiser ,
Thanks for the ask and using the Microsoft Q&A platform .

I am not sure if I understand the ask here , but can you not an JOIN query in the Lookup and make it work ?

SELECT * FROM dbo.Morneau05Control a
Join TheOtherTable B
ON A.RecordType = B.RecordType


Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members


· 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.

Hello @ewinkiser ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello @ewinkiser ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·