Hi Prasad Kuppuri ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
As per my understanding you are trying to flatten json data using dataflow in ADF , however, it's not doable .
Flatten transformation requires 'Array' data to 'unroll by' . Kindly use 'collect' function in 'aggregate' transformation to convert complex datatype into array format and then use it to unroll by.
For more details on the implementation , kindly check out the following post:
Hope it helps. Kindly accept the answer if it was helpful. Thankyou