Import table with named range as string from table in power query and evaluate

[jaryszek]

Hi,

It is possible to take table like here (import from CSV):

Screenshot_45.png

import to power query and evaluate named ranges based on strings?

So if in workbook NamedRange1 = 1 i should import this table from CSV and evaluate named range from string?

Jacek

[Norie]

Add a column with this formula to the table in Power Query.

= Table.AddColumn(#"Changed Type", "Custom", each Excel.CurrentWorkbook(){[Name=[Servers]]}[Content])

That would return each named range as a table.

[jaryszek]

o wow it worked!!!

Awesome thank you very much Norie!

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"EntityName", type text}, {"Topology", type text}, {"Tier", type text}, {"Servers", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Excel.CurrentWorkbook(){[Name=[Servers]]}),
    #"Expanded Custom1" = Table.ExpandRecordColumn(#"Added Custom", "Custom", {"Content", "Name"}, {"Custom.Content", "Custom.Name"}),
    #"Expanded Custom.Content" = Table.ExpandTableColumn(#"Expanded Custom1", "Custom.Content", {"Column1"}, {"Custom.Content.Column1"})
in
    #"Expanded Custom.Content"

Screenshot_47.png

Jacek