Sublist list by excel id

Hello friends!

I have the following situation. I need to create a list separated by the filter.

In other words, I need to create a list with all attributes, from all columns, but separated by filter.

For example, if I wanted to filter by 2 (this information would be in column B, in excel) the result would be this

And, from that, be able to work with other nodes according to the filters I make

Hi @gabriel.souza ,

Have you tried List.GroupByKey?

1 Like

Hi, @Daan !

I actually used it, but I’ll try again… maybe I’m not using it the right way.

Can this node do what I mentioned above?

I have my general list, and can I create a new list filtering according to the filter in the FILTER column (column B) and bring me all the information from all the columns?

I’m working on something else, but I’ll be back to testing this node soon.

You would maintain the full sublist (row) as your “item” and then filter by just the one value (key) in column B. With GroupByKey this would give you each row grouped by filter value and then you just need to “select” the filtered groups.

Hi @gabriel.souza ,

I’ve created a small sample, didn’t use List.GroupByKey though:


2022-01-18 Filter Excel by data in Specific Column.dyn (16.4 KB)

PS: Just make sure the == node is comparing integers with integers, doubles with doubles or strings with strings.

2 Likes

Perfect, @Daan! And everyone who commented!!

Thank very much!