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

**jaryszek** · 11-20-2020, 11:13 AM

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** · 11-20-2020, 11:37 AM

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** · 11-21-2020, 04:29 AM

o wow it worked!!!

Awesome thank you very much Norie!

Please Login or Register  to view this content.

Screenshot_47.png

Jacek

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Power Query to Convert Data Range to a Table

Power query on mac from table/range

How to create dynamic source for a pivot table from a append table in power query

Add custom fields to a table to simulate a pivot table - Power Query

Power Query and Power Pivot Table !!

POWER Query and Power Pivot Table !!

[SOLVED] Is there an option in Power Query to import Named Ranges

Bookmarks

Bookmarks

Posting Permissions