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.
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
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
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...)
You just nailed it. Awesome keep doing great work.
Thank you Pradeep 😀
i realize I'm pretty off topic but do anybody know a good website to watch new tv shows online ?
@Joel Kaysen I dunno I'd suggest Flixportal. you can find it by googling:) -remy
@Remy Conner Thanks, I went there and it seems like a nice service =) I really appreciate it!!
@Joel Kaysen You are welcome xD
Good Explanation... Very detailed description for each transformation...
Thank you 🙂
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.
Awesome..just what i wanted today for my project ❤
Thank you 😊
cant we use regex method
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
Can we use data lata analytics with free trial?
Very nicely explained.. 🙂 Thanks
Thank you ☺️
Perfect 👌 Thanks for explaining
Thank you 😊
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
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...)
u can do that bro u can add second level in second flow ..and in the first step u can create condition
Excellent bro
Thank you ☺️
Nice...very useful
Thank you ☺️
well done!
Thank you 🙂
Instead of replace, should not we use join(skill,',')
👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
☺️
Awesome.. just what i wanted today for my project❤
Thank you 😊
Thank you 😊