Create a sublist when you find a certain value

1

Hi all,
I am wondering what is the easiest way to create sublists from a list of numbers when a certain value is present.
I mean…I have this list of numbers and I’d like to have its sublists every time 0 is found. How can I do?
image

Thanks in advance!

2

Here is one such way:

image
image1620×551 94.3 KB

1 Like
3

Hi @jacob.small thank you for your reply.
Maybe I am not understanding you but what I want is to create sublists everytime it finds a certain value (in my case 0). 0 as value not as list value
According to the example in my screenshot I should have 2 sublist like shown:
image

1 Like
4

Yep - I used 1.0 as my divider but I believe that 0.0 works just as well.

5

Hi @robertoruggeri

How about this?

image
image.png1866×744 77.3 KB

6

Hi @kulkul do you know why it gives me an empty list with the List.AllIndicedOf.
What am I wrong?
image

7

Try 2.0 - you’re comparing an integer to a double. :slight_smile:

8

@jacob.small thank you so much :slight_smile:

9

ehy @jacob.small even if it’s an offtopic, do you know why when I use List.RemoveItemAtIndex then I cannot use the results with List.Flatten (and also I cannot see them on Watch)
image

10

You don’t have two levels to flatten - try using a -1 or 1.

1 Like
11

Thank you @jacob.small, now it works.
While we’re talking about list, now I have 2 lists and I want to find the three values of List.UniqueItems 9,2,11 in List.Transpose, checking only the 0 index of that list in @L1. The result is the matching sublist with
2
5.5
0
0.
Is it possible to do it without coding? If no, what do you suggest?

image
image.png405×662 19.9 KB