Thank you for this post! At the step where you create the group by using the surrogate (around 21 minutes), you first sort by column name. How do we know the second maintains the integrity of the original rows? That is, how do we know that Amount 1 and Currency 1 both came from the original row 1? Seems possible that ADF could jumble this up.
Hi, At minute 21:40 with the iff you explain to us about the number of records, how can this number of records be obtained automatically based on what the json file contains? Thanks for your help
Thankyou for watching the video.. In that case we need to parameterize the expression in derive column transformation and pass the integer via pipeline paramter during the runtime
Hi,thanks for sharing your knowledge,can you please share the the input files, in description from coming vedios it will be more helpful, How to parameterize the flatten column .?
Thank you for this post! At the step where you create the group by using the surrogate (around 21 minutes), you first sort by column name. How do we know the second maintains the integrity of the original rows? That is, how do we know that Amount 1 and Currency 1 both came from the original row 1? Seems possible that ADF could jumble this up.
Hi, At minute 21:40 with the iff you explain to us about the number of records, how can this number of records be obtained automatically based on what the json file contains?
Thanks for your help
we can parameterize the expression in derive column transformation and pass the integer via pipeline paramter during the runtime
@@azurecontentannu6399 Thanks for your help.
@@azurecontentannu6399 can you give an example of how to include this in the expression builder
Hi, What about in case the input has n of rows since you mentioned example for 3 array set.
Thankyou for watching the video.. In that case we need to parameterize the expression in derive column transformation and pass the integer via pipeline paramter during the runtime
Hi,thanks for sharing your knowledge,can you please share the the input files, in description from coming vedios it will be more helpful,
How to parameterize the flatten column .?
@@naveenraj9977 I have added the input json in the description. Thankyou
@@azurecontentannu6399 that was Great & Thanks for reminding me..!