

February 1, 2019

Hi Guys,
i am downloading table from web
The issue is that i am getting List in rows instead of textes:
How to now expand all the lists ?
When i am drilling down i am getting only seperated lists in next step:
the goal is to get table from linked website.
Can anybody help?
Best,
Jacek


November 8, 2013

You will need a recursive function, there are more nested lists.
Here is one (name it CombineList):
(Item as any)=>
let
Text= if Value.Is(Item, type list) then
List.Accumulate(Item,"",(state,current)=> Text.Combine({if Value.Is(current, type list) then CombineList(current) else current,state}," ") )
else
Item
in
Text
Then just add a new column in your query, calling this function:
= Table.AddColumn(#"Changed Type", "Custom", each CombineList([Przychody ewidencjonowane]))

Answers Post
1 Guest(s)
