Combine two lists

Hello everyone,

I would like to ask if someone can assist with the following:

I would like to combine two lists (Red & Blue) based on a third list (Yellow) - all lists have the same size - as shown in the following screenshot:

In more detail i have a list of 8760 hours (Highlighted in Yellow) where each hour has a 0 or 1 value.

I would like to combine the first two lists into one based on the 0 and 1 values. For every 0 value i need to get values from one list and for each 1 values get results from the other list. Is that possible?

According to your description, it sounds like what you are looking for is Pick’n’choose.

(Sets–>LIst–>Pick’n’choose)

Hi Kim,

Thanks a lot for your response.

The Pick n Choose works fine but i have an additional problem.

The lists i nwant to combine have 14 nodes. and 8760 values for each node (122640values)

The list with the 0 and 1 values has only 1 node and 8760 values.

The resulted list is correct buy it takes only the N=1 values. Can i do something to include all nodels (N=14).

Many thanks

Try to flatten your pattern input.

1 Like