# Create a sublist when you find a certain value

**URL:** <https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558>\
**Category:** Uncategorized\
**Created:** [May 3, 2019, 9:07pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558 "2019-05-03T21:07:43Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![robertoruggeri](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@robertoruggeri](https://forum.dynamobim.com/u/robertoruggeri)\
**Post date:** [May 3, 2019, 9:07pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/1 "2019-05-03T21:07:43Z")

</div>

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](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/9/59906c54876bae7dcdffb2c1f5cfeed2ca07a984.png)

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [May 3, 2019, 9:15pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/2 "2019-05-03T21:15:50Z")

</div>

Here is one such way:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/4/44832e7ecccadf219599b991d82b3b05e9fe5a42.png)

---

<div class="post-metadata">

**Author:** ![robertoruggeri](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@robertoruggeri](https://forum.dynamobim.com/u/robertoruggeri)\
**Post date:** [May 3, 2019, 9:29pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/3 "2019-05-03T21:29:07Z")

</div>

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](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/3/d3452741e36d0283a774bb25d95afc1cf0b44e8b.png)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [May 3, 2019, 10:18pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/4 "2019-05-03T22:18:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [May 4, 2019, 4:29am UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/5 "2019-05-04T04:29:54Z")

</div>

Hi @robertoruggeri

How about this?

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/3/b34f6ce4739724b422cc193fcba2ab26a71f3d3a.png)

---

<div class="post-metadata">

**Author:** ![robertoruggeri](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@robertoruggeri](https://forum.dynamobim.com/u/robertoruggeri)\
**Post date:** [May 4, 2019, 7:39pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/6 "2019-05-04T19:39:16Z")

</div>

Hi @kulkul do you know why it gives me an empty list with the List.AllIndicedOf.  
What am I wrong?  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/9/29b5b466504658a0f9f9b0685de26b495670a61d.png)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [May 4, 2019, 8:59pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/7 "2019-05-04T20:59:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![robertoruggeri](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@robertoruggeri](https://forum.dynamobim.com/u/robertoruggeri)\
**Post date:** [May 4, 2019, 9:08pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/8 "2019-05-04T21:08:57Z")

</div>

@jacob.small thank you so much 🙂

---

<div class="post-metadata">

**Author:** ![robertoruggeri](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@robertoruggeri](https://forum.dynamobim.com/u/robertoruggeri)\
**Post date:** [May 4, 2019, 9:14pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/9 "2019-05-04T21:14:31Z")

</div>

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](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/4/f4c8a74817c546eee953bbc358b28b03c8088d6a.png)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [May 4, 2019, 9:21pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/10 "2019-05-04T21:21:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![robertoruggeri](https://avatars.discourse-cdn.com/v4/letter/r/58956e/32.png) [@robertoruggeri](https://forum.dynamobim.com/u/robertoruggeri)\
**Post date:** [May 4, 2019, 10:02pm UTC](https://forum.dynamobim.com/t/create-a-sublist-when-you-find-a-certain-value/35558/11 "2019-05-04T22:02:35Z")

</div>

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](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/b/3b91cc463ec0295c0b63b4f227fd54c660242440.png)
