question

arkiboys avatar image
0 Votes"
arkiboys asked MarkKromer-MSFT answered

expression error

I do not get an error here in the visual expression builder but in the column pattern window the error is shows as:

Expression could not be evaluated for matched column.
Do you know why?
Thank you

147398-image.png


147310-image.png


azure-data-factory
image.png (19.9 KiB)
image.png (14.9 KiB)
· 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 again @arkiboys . Could you give a few example values for that column? Perhaps there is a type mismatch?

0 Votes 0 ·

1 Answer

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

Try it using $$ instead of $0

· 2
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.

I'm going to publish an update to the column patterns docs to help explain the difference in the pattern syntax ($$ vs $0) better here: https://docs.microsoft.com/en-us/azure/data-factory/concepts-data-flow-column-pattern#pattern-matching-expression-values

1 Vote 1 ·

Thank you

0 Votes 0 ·