List.FilterByBoolMask

List.FilterByBoolMask(List0,mask)
List.FilterByBoolMask({1,2,3,4},{true,false,false,true})

In this way you will have a list with two sublists. Separate sublists will doesn’t work with classic code. You need a little trick. Create a list of a given list, then return a flatten list with one less sublist.
ListFBBM = List.Flatten({List0},1);
ListFBBM_in = ListFBBM[0];
ListFBBM_out = ListFBBM[1];

Or use the following method:
ListFBBM_in = __TryGetValueFromNestedDictionaries(ListFBBM, “in”);
ListFBBM_out = __TryGetValueFromNestedDictionaries(ListFBBM, “out”);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s