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
Hello @bcole,
I included a pipeline in the post that evaluates the array by using the array filter function. If the array objects, are filtered out based on the AI_Status field (their value is 8,16 or 32), and the array is not empty, then that means one of the AI_Statuses has some other value.
I named that additional field as routingPath which can be easily used for further processing, in your case routing.
Routing_FieldValue_2022_11_10.slp (11.7 KB)
Hope this helps,
Bojan
Bojan,
I think that solutions works nicely. Thank you so much. I just have one other question. What is the best way to add a value, specifically the IpaasQueueId , and EntityKey to Rows that are further down stream like after the stored procedure snap. The first SQL Snap and the second snap have an EntityKey = ContextName relationship. I need that and the IpaasQueueId from the first SQL call.
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!
