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...