Monday, 5 December 2016

List.Deconstruct

List.Deconstruct(List0)
List.Deconstruct({1,2,3,4})

In this way you will have a list with two sublists. If you want two separated lists you need to extract the first sublist using code ListD[0] and ListD[1] for the second. But it will doesn't work. You need a little trick. Create a list of a given list, then return a flatten list with one less sublist: List.Flatten({List0},1).
Now you can split in two lists.

No comments:

Post a Comment