derived column pattern

Question

arkiboys 9,711

Hello,
What is wrong with this value expression?
The error is:
'Config#lookup' at parameter '1' expects 'string' type of argument

iif( (toDate(toString(byName($0)),Config#lookup($0).SourceFormat)) < (toDate('2010-01-01')) ,"Fail","Pass")

Note, there is no differentce in the error message if I use $$ instead of $0

Thank you

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2022-01-06T14:35:56.48+00:00

Hello @arkiboys ,

Thanks for the question and using MS Q&A platform.

Are you getting the error during the runtime ?

I just checked the expression - using a sample/random data at my end.

I did not encounter the error in the preview :
arkiboys 9,711 Reputation points

2022-01-06T14:37:59.067+00:00

Hi,
It looks to be working fine as I re-created the dataflow from scratch.

Thank you
arkiboys 9,711 Reputation points

2022-01-07T10:07:43.177+00:00

Hello,
It seems that often the expression looks to be red indicating error with the error message as noted previously.
If I re-create the dataflow then all works fine but it appers that often for what-ever reason the same expressions fail.
Any thoughts?
svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2022-01-12T09:38:20.22+00:00

Hello @arkiboys ,

I am checking on this further and I'll get back.
AddaBo 1 Reputation point

2022-02-15T12:11:29.91+00:00

I got the same problem when I use "StandardCache#lookup($$).TransformationFormula" in the value expression. Has this Issue been solved?

Your answer

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2022-01-06T14:35:56.48+00:00

Hello @arkiboys ,

Thanks for the question and using MS Q&A platform.

Are you getting the error during the runtime ?

I just checked the expression - using a sample/random data at my end.

I did not encounter the error in the preview :
arkiboys 9,711 Reputation points

2022-01-06T14:37:59.067+00:00

Hi,
It looks to be working fine as I re-created the dataflow from scratch.

Thank you
arkiboys 9,711 Reputation points

2022-01-07T10:07:43.177+00:00

Hello,
It seems that often the expression looks to be red indicating error with the error message as noted previously.
If I re-create the dataflow then all works fine but it appers that often for what-ever reason the same expressions fail.
Any thoughts?
svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2022-01-12T09:38:20.22+00:00

Hello @arkiboys ,

I am checking on this further and I'll get back.
AddaBo 1 Reputation point

2022-02-15T12:11:29.91+00:00

I got the same problem when I use "StandardCache#lookup($$).TransformationFormula" in the value expression. Has this Issue been solved?