Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. let
  2. GetWorkItemsPages = (ids as list) =>
  3. let
  4. Pages = List.Numbers(0, Number.RoundUp(List.Count(ids) /200)),
  5. #"Convert to Table" = Table.FromList(Pages, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
  6. #"Split List to CSV" = Table.AddColumn(#"Convert to Table", "Custom", each Text.Combine(List.Transform(List.Range(ids, [Column1]*200, 200), each Text.From(_)), ",")),
  7. #"Removed Columns" = Table.RemoveColumns(#"Split List to CSV",{"Column1"}),
  8. Custom = #"Removed Columns"[Custom]
  9. in
  10. Custom
  11. in
  12. GetWorkItemsPages
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement