

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

Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service

November 8, 2013


Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service

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)
