Share via

How to Use azure data factory -> dataflow $0,$#

ri,shoshun 431 Reputation points
2021-07-01T07:29:48.013+00:00

How to Use $0,$# in azure dataflow->DerivedColumn->Add column pattern.
Thanks for your help!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
Accepted answer
  1. MarkKromer-MSFT 5,226 Reputation points Microsoft Employee Moderator
    2021-07-01T19:44:05.367+00:00

    The data flow $ syntax represents dynamic pattern values.

    $$ can be thought of as equivalent to "this" in other programming languages and is used in pattern matching to represent current row value.

    $0 and $# are new constructs we just recently added to the data flow grammar. The docs should land next week.

    You will be able to use $0 to represent current dynamic column names in column patterns. $# refers to the current column position.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ri,shoshun 431 Reputation points
    2023-11-10T02:19:49.35+00:00

    @William Lai

    Below is how I use it:

    Dataflow parameter (my_string_array), default value:

    　["1","2"]

    Dataflow expression:

    　$my_string_array[toInteger($#)]

    1 person found this answer helpful.
    0 comments

Your answer

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