@Majid I’m glad the above helped.
I think I may be derailing too much by suggesting the expression library. It was a creative thought, but would require readjusting downstream logic to reach desired end result.
But, for an exercise, I put this together to show where my thought was leaning.
It basically changes your source:
{
"UBER_ID": [
"1",
"Integer_pattern"
],
"First_name": [
"Majid",
"TextOnly_pattern"
],
"Last_name": [
"",
"TextOnly_pattern"
]
}
to this:
{
"UBER_ID": [
"1",
"Integer_pattern",
"valid"
],
"First_name": [
"Majid",
"TextOnly_pattern",
"valid"
],
"Last_name": [
"",
"TextOnly_pattern",
"invalid"
]
}
But you’d still have to handle this creatively in downstream snaps to get your desired results.
Community.10510.v3_2021_08_06.slp (4.9 KB)
community10510v3.expr.txt (376 Bytes)