Column as a parameter

[Anonymous]

Hello,

Here is my code : 

let
DisplayListWithoutDelimiters = (tablelist as table, column as text) =>
let
Hoho = tablelist[column]
//OneElement=Table.ReplaceValue(TableList, each [Column], each if List.Count(Text.Split([Column],";")) = 1 then Text.BeforeDelimiter([Column], "¤")&", "
//else if List.Count(Text.Split([Column],";")) = 2 then Text.BeforeDelimiter([Column], "¤")&", "&Text.AfterDelimiter([Column], "¤", {0, RelativePosition.FromEnd})&", "
//else if List.Count(Text.Split([Column],";")) > 2 then GetTextBetweenDelimiters([Column],"¤", ";", null)
//else null, Replacer.ReplaceText, {Column})

in 

Hoho

in 

DisplayListWithoutDelimiters

When I call my function : = DisplayListWithoutDelimiters(Table1, "Test")

I have an error message saying " column can't be find in the table "

It seems that the expression between the brackets can't be recognized as a parameter... 

column is a parameter and in this call it should be replaced by test so it should be Table1[test]

Thanks for you help !

[v-yuta-msft · Accepted solution]

@Anonymous ,

Because in the new blank query, you have no table column, you should copy the columns from another query, modify the M code like below:

let
    DisplayListWithoutDelimiters = (tablelist as table, column as text) as table => 
    let 
        Hoho = Table.SelectColumns(#"tablelist", column)
    in 
        Hoho
in 
    DisplayListWithoutDelimiters

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.