24. How to Copy Complex multi-array JSON into tabular format using mapping dataflow

No video

24. How to Copy Complex multi-array JSON into tabular format using mapping dataflow

Рет қаралды 810

Azure Content : Annu

Күн бұрын

Пікірлер: 10

@KentuckyJIm41004 6 ай бұрын

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.

@MohammedKhan-np7dn Жыл бұрын

Hi, What about in case the input has n of rows since you mentioned example for 3 array set.

@azurecontentannu6399 Жыл бұрын

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

@naveenraj9977 Жыл бұрын

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

@azurecontentannu6399 Жыл бұрын

@@naveenraj9977 I have added the input json in the description. Thankyou

@naveenraj9977 Жыл бұрын

@@azurecontentannu6399 that was Great & Thanks for reminding me..!

@andrespi5 8 ай бұрын

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

@azurecontentannu6399 8 ай бұрын

we can parameterize the expression in derive column transformation and pass the integer via pipeline paramter during the runtime

@andrespi5 8 ай бұрын

@@azurecontentannu6399 Thanks for your help.

@rijinjose8138 Ай бұрын

@@azurecontentannu6399 can you give an example of how to include this in the expression builder