5

Easily reference "current field" in SQL snippets and custom transformations

In many transformations you need a reference to the "current field". Example a tranform in [Field A] could be:

coalesce(nullif( [Field A], N''), N'Unknown')

In this case, it would be a huge improvement of we could something like the following instead of having to assign a parameter. Especially when working with SQL snippets it would greatly improve usability as it allows drop-in snippets that don't need parameterization.

coalesce(nullif( [CURRENT_FIELD], N''), N'Unknown')

It should be noted that in the case of a self-reference, having an actual parameter has little benefit anyway as a self reference has no lineage impact

 

6 comments

Please sign in to leave a comment.