Forum Discussion

jct999's avatar
jct999
Icon for Advocate II rankAdvocate II
5 years ago
Solved

[PowerQuery] Function to add columns based on a list of column names

Hello everyone, I would like to create a function that do the following : Given 2 parameters : - A table - A list of name for new columns. Ex: {"COUNTRY", "CUSTOMER_NAME"} Return : The input...
Need Help
  • jct999's avatar
    jct999
    5 years ago

    Here is the solution I found. (May be helpfull for others)

     

    let myFunc = ( myTable, myNewColumnList) =>

    let foo = List.Accumulate(

    myNewColumnList,
    myTable,
    (current_table, new_name) =>

    if List.Contains(Table.ColumnNames( current_table), new_name)
    then current_table
    else Table.AddColumn(current_table, new_name, each null)

    )

    in foo

    in myFunc

jct999's avatar
jct999
Icon for Advocate II rankAdvocate II
5 years ago

Here is the solution I found. (May be helpfull for others)

 

let myFunc = ( myTable, myNewColumnList) =>

let foo = List.Accumulate(

myNewColumnList,
myTable,
(current_table, new_name) =>

if List.Contains(Table.ColumnNames( current_table), new_name)
then current_table
else Table.AddColumn(current_table, new_name, each null)

)

in foo

in myFunc

broy32000's avatar
broy32000
New Member
2 years ago

Hi, I am trying to add value to the added column based on a condition. But it's failing with the message: "Expression.Error: The name 'current_table' wasn't recognized. Make sure it's spelled correctly."  Would you please provide some insight?

 

let myFunc = ( myTable, myNewColumnList, V1) =>

let foo = List.Accumulate(

myNewColumnList,
myTable,
(current_table, new_name) =>

if List.Contains(Table.ColumnNames(current_table), new_name)

then current_table
else

let
condition = if new_name = V1 then V1 else "excluded"
in condition ,

Table.AddColumn(current_table, new_name, condition)
)

in foo

in myFunc