Thank you very much for such a nice explanation.
What do you mean by current?
Oh Thank you. It worked! You are the best Catalin! Few Questions: 1. Text.Contains(_,"Cat") --> what does "_" it means? The resul...
Ok Guys, i am returning back because i do not understand how to crate this dynamically from scratch. I have file like in attachment. And the...
Thank you very much for help Catalin, Best ! Jacek
Hi i am going there. Sorry if i posted wrongly. There is no solution for my question there. There was entirely different topic with comparing 2 t...
ok, thanks. I have TableList query like here: let Source = Excel.CurrentWorkbook(){[Name="TableList"]}[Content], #"Changed Type" = Table.Tr...
I also tried: let TableName = "Table1", Source = TableList, #"Grouped Rows" = Table.Group(Source, {"TableName"}, {{"ColumnsToKeep", each _, type ...
Hmm i was trying to add column and create list from Table. The syntax is: Table.Column(table as table, column as text) as list i have no idea what...
Thank you very much. Ok i got it but still struggling with changing table to list type 🙂 let TableName = "Table1", Source = TableList, #"Grou...
Hi Catalin, thank you. i see the issue. I have this query with ColumnsToKeep in function but it is creating table which is not the list. C...
Hi Catalin, ok but function fnGetColumnsToKeep is working while invoking function. Ok so what should i do? let TableName = "Table1", Colum...
Anyone? Best, Jacek
Ok i added function fnGetColumnsToKeep: (TableName)=> let #"Filter" = Table.SelectRows(TableList, each ([TableName] = TableName)) in #"Filter"...