Date Validation using Expression Library
Hi,
I’m developing a pipeline that uses date input parameters. I was looking to use an expression library to validate the date format by matching a regex pattern.
For example, /^([1-9]|0[1-9]|1[...
Forum Discussion
Hi Bhaskar ,
You can use ternary operator to replace null value with number.
eg:- $firstname==‘null’?0:‘’
It worked. Had to remove the quotes before and after NULL.the condition looked like
$firstname==null?2:$firstname
Thanks much for the idea
This is fantastic! I was looking for a way to dynamically pivot without having to hard code the columns in a Pivot Snap since the number of columns I wanted to pivot on was changing. Thanks!
