Am i doing this right? Filter Data Table Activity

Is my understanding of how the Fileter data table activity works correct?

FROM DataTable ‘dtZRFTC0004’ IF 'Network ’ starts with “1” THEN keep columns ‘Purchase order’ and 'Network ’ in new Data Table ‘dtEKKN’.

Below is the Filter Criteria
image

Below is the output
image

Hi @Waterfowl_Waterfowl_hunte

Could you be more specific… Your query is quite confusing.

If you share the Input file and Expected output data then we are able to understand the query.

@Waterfowl_Waterfowl_hunte,

Try putting 1 as “1” if your column datatype is string.

Thanks,
Ashok :slightly_smiling_face:

That was it! Thank you!

As a new developer its these little details that are the toughest to learn.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.