Hi @MT90CO01 ,
Welcome to the forum!
Have a read though the posts here
@Fed17 - In your last post you are trying to filter a list of strings using a numbers. This will only return null values. See image below:
[Number%20vs%20String]
With filter masks you want two lists of equal size. One with your data and another of Booleans. You then use the booleans to filter the data list into two outputs. Essentially into true values and false values
See below:
[Filter%20by%20Mask]
Hope that help explain those two issues.
In regards, maybe try this:
[Solution]
I covered a fair amount of detail in regards to handling blank data, nulls and filters via mask. Hopefully the information will present you with a solution.
Best,
Ben
1 Like