Day 07 #30DQUERY

08-05-2020 The Challenge

DAY 7 
Database: AdventureWorksDW2017 
Entity: DimEmployee 
Instructions: 
Dynamically select all the columns that do not contain the text 'Key'.

Future proof

My route

From Owen Auger

From Barrett Studdard

// Find valid columns 
column_list • each not Text.Contains(_, "Key")),
  • 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