Forum

Hi Catalin, 1.why to use table to import named range? Can not just directly import it? 2. Assume that "namedrng" is is not named range in cell....

I am attaching example workbook. here is a string which PQ should take, and evaluate inside (it is the name of named range in names manage...

Thank you Guenter, I only had this problem when I copied a workbook to another computer Exactly. When i sharing file in somebody else comput...

Hi Guenter, thank you. Let's focuc first on ad 7) This I do not understand. What do you mean with workaround? You added custom columns...

And one more issue i have with your poqwer query: #"Added TopoIndex" = Table.AddColumn(#"Removed Columns1", "TopoIndex", each "Index" & [Topo...

Thank you very much! O wow this is working like a charm. You can overcome this by using here also a dynamic aproach for column names and numb...

Hi Guenter Weber, i analyzed your queries and they are awesome. I have one more question for you. I want to add function which will be retrivin...

Thank you very much! Your solution is very nice ! But i have to analyze it more and i will come back with questions. Best, Jacek

O wow thank you very much!! It is working like a charm! Best, Jacek

Or i can create empty row in Power Query somehow like here: // create an empty record EmptyRecord = let FieldNames = Record.FieldNames(FirstRecor...

Hi Mynda, thank you very much. in PQ there is an option to handle errors using Try function. But i do not know how to implement it. The topic i...