08-05-2020 The Challenge
Future proof
My route
- What is the formula to selectcolums
Table.SelectColumns(table as table, columns as any, optional missingField as nullable number) as table - In the home Tab, there is an option Choose Columns and I selected all columns that do not contain the tekst ‘Key’ with this option.
And yes I now see the columns I need. - I think something should be done with the word Dynamically, because if now 1 row will be added to the original dataset it will not be in this filter.
From Owen Auger
From Barrett Studdard
- So lets start looking in the documentation for Tekst.contains and List.select
From what I find I cannot bring that together with the used code by the two people.
Looking at List.select I now see why those two are in combination with each other; List.Select gives a list and Tekst.Contains gives True or False
My result
