Get only those lists with sub list filter criteria

hey I have some 88 lists, with 0 - Task name 1-Baseline Durations 2- Actual Duration 3-Delay
i want only those lists with some delay, i.e. non zero values in index 3.
i was trying some filters, but seems not to be working for me!

image
image

I’d start by Transposing your lists (so that each sublist represents a single type). Then you can check for strings starting with “0” in your 4th list.

1 Like

okay, so how do i get the items from 1st list associated with only non zero values in the 4th list?

1 Like

You need to isolate the 4th list. Then you can use FilterByBoolMask to mask the original list with those conditions .

1 Like

thanks for your time, but i wanna get names of those tasks which have non-zero delay, refer to 1st screen shot in the post

okay so i got the indexes of non zero values, but they start repeating at index 8, coz they have values, what could be the sol?

You’re still filtering the list of delays rather than the original list (or the list of names if that’s all you need).

1 Like

yes as you asked me to isolate 4th list, so im filtering it as per my condition

You do need to isolate the 4th list, yes, but then you need to filter the original list (or the names list) to get the names that match your conditions.

1 Like

you are a genius man, thankyou for your time! appreciated! :heart_eyes: