Forum Discussion

swatifunde's avatar
swatifunde
Contributor
3 years ago
Solved

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” }, ...
  • darshthakkar's avatar
    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