swatifunde
3 years agoContributor
Filter the data
Hello Community,
Below is input
[
{
“name”=“ABC”
“ID”=“D.0012”
},
{
“name”=“XYZ”
“ID”=“B.002”
},
{
“name”=“OPQ”
“ID”=“E.0012”
},
{
“name”=“LMN”
“ID”=“J.0012”
},
...
- 3 years ago
@swatifunde - The simplest approach is to use a filter snap and put a condition of startsWith either J or C. Snap below:
Would the ID be always in the format of “Letter.(number)(number)(number)(number)”?
If yes, you can use the above-mentioned approach. Also, if you’re expecting ID to be Null/blank and want them to pass, please do select “Null-safe access”.Regards,
Darsh