22. Merge Multiple rows in to Single row using Mapping data flow in Azure Data Factory

In this video, I discussed about how to merge multiple rows in to single row using mapping data flow in azure data factory
Link for Azure Synapse Analytics Playlist:
• 1. Introduction to Azu...
Link for Azure Databricks Play list:
• 1. Introduction to Az...
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
Link for Azure Data Factory Real time Scenarios
• 1. Handle Error Rows i...
Link for Azure LogicApps playlist
• 1. Introduction to Azu...
#Azure #AzureDatafactory #DataFactory

[@priyankadp5777]

Awesome..just what i wanted today for my project ❤

[@WafaStudies]

Thank you 😊

[@pradeepcheekatla5078]

You just nailed it. Awesome keep doing great work.

[@WafaStudies]

Thank you Pradeep 😀

[@joelkaysen2452]

i realize I'm pretty off topic but do anybody know a good website to watch new tv shows online ?

[@remyconner1260]

@Joel Kaysen I dunno I'd suggest Flixportal. you can find it by googling:) -remy

[@joelkaysen2452]

@Remy Conner Thanks, I went there and it seems like a nice service =) I really appreciate it!!

[@remyconner1260]

@Joel Kaysen You are welcome xD

[@sunilgeorge4284]

Hello Maheer, I think we can do the array to string conversion using the same Aggregator step itself. Also the approach you shared will allow us to get the array values separated by "," always. I won't be able to get it as pipe separated if that is the requirement. Try this reduce function on top collect in Aggregator step itself.
ltrim(reduce(collect(Email),'',#acc + '|' + #item, #result),"|")
Great videos, and thanks for taking your time and creating these useful videos for us. Keep going.

[@sivagssri]

Good Explanation... Very detailed description for each transformation...

[@WafaStudies]

Thank you 🙂

[@AshishKumar-qk9rc]

Very nicely explained.. 🙂 Thanks

[@WafaStudies]

Thank you ☺️

[@AnnuKumari-mo6gz]

Perfect 👌 Thanks for explaining

[@WafaStudies]

Thank you 😊

[@gouthamsreeram3533]

Excellent bro

[@WafaStudies]

Thank you ☺️

[@sudheermattapally2791]

Nice...very useful

[@WafaStudies]

Thank you ☺️

[@priyankapatimidi2392]

Nice video, I have interview with Microsoft for ADF this week, so can you please give some info, what areas they will cover mostly and the type of questions

[@kromerm]

well done!

[@WafaStudies]

Thank you 🙂

[@zikoraswrld]

Instead of using collect. Is there a way I can take a total sum of the skills if they were numbers. Also what if I the sink to be loaded into the same table but replace the stuff in the table with the merged data

[@cloudfitness]

👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

[@WafaStudies]

☺️

[@AnandKumar-dc2bf]

Hi Bro,
Can u do 1 video on mail approval using logic app (ex: the mail shud be approved by 1 level manager and then it shud go to 2 level manager for final approval...)

[@datainference9239]

u can do that bro u can add second level in second flow ..and in the first step u can create condition

[@avirajankitjain256]

cant we use regex method

[@AwakeYour3rdEye]

Instead of replace, should not we use join(skill,',')

[@nileshakodiya]

Can we use data lata analytics with free trial?

[@priyankadp5777]

Awesome.. just what i wanted today for my project❤

[@WafaStudies]

Thank you 😊

[@WafaStudies]

Thank you 😊