Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
How to Calculate Percentage of each row element in ADF which uses Sum of all elements present in a particular column in mapping data flow Azure Data Factory ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Aniket Ghodinde
1
Reputation point
I need to calculate percentage of each row element, with respect to column total. I did aggregate transformation and found TOTAL of particular column but I am not able to used it derived column transformation to find percentage.
I tried to used Cache Lookup and dataflow parameter but it didn't work.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,061 Reputation points2021-09-14T06:39:20.993+00:00 Hello @Anonymous and welcome to Microsoft Q&A.
Could you give a little more information on how the Cache Lookup did not work, and how the parameter did not work?
-
Aniket Ghodinde 1 Reputation point
2021-09-14T08:30:24.127+00:00 When I used Parameter, I got Error:
DF-EXPR-010 at Derive 'DerivedColumn9'(Line 295/Col 46): Column 'GRAND_TOTAL' not found. The stream is either not connected or column is unavailable.When I used Cache Lookup, I got Error:
No result available for stream 'sink1'
Sign in to comment