Azure Data Factory Dataflow - Window Transformation Column Pattern Issue

Mohamed Asik 1 Reputation point
2021-04-14T15:46:08.907+00:00

I'm facing an issue, when I add a column pattern to make a function that affects all columns matching a particular criterion, even if the function successfully resolves and the dataflow is saved, the expression is gone when you re-enter the dataflow again.
I am doing this on a ‘Window’ type transformation - Column pattern
The expression used is:
Matching condition :
type == 'double'
Field: $$
Expression : avg($$)

87891-windowtransformcolumnpattern.png

This expression helps to find the type 'double' on the columns and calculate Avg salary. The same column pattern works well in derived column activity.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.