question

lsc2021 avatar image
0 Votes"
lsc2021 asked lsc2021 commented

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

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

azure-data-factory
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Isc2021 and welcome to Microsoft Q&A.

In building column patterns, $$ refers to the currently matched thing.

I do not see where you are getting $0,$# from. Could you please give an example?

Are you looking at expressions like toInteger('$123', '$###') ?


0 Votes 0 ·

1 Answer

MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered lsc2021 commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI @MarkKromer-MSFT

Thank you for your reply!

0 Votes 0 ·