Forum Discussion

sparvez's avatar
sparvez
Helper I
3 years ago
Solved

List.Accumulate source column name

Hello altrusits,

 

 Can someone help me how to choose a column name as a source for the function  List.Accumulate ?

Thanks in advance. 

 

My code is as follows:

= Table.AddColumn(#"previous step", "new column", each List.Accumulate(Table.ToList(#"Table list  here, this table has many columns so I want to specify the column name"),"",(state,current)=>

if Text.Contains([column to look forl],current,Comparer.OrdinalIgnoreCase)
then current&"/"&state
else state))

Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi sparvez,

     

    I guess you are questioning this bit?

    Text.Contains([column to look forl],current,Comparer.OrdinalIgnoreCase)

    You can call a column in a table using the name of the column using

    Table.Column(table as table, column as text) as list

     

    Kind regards,

    John 

2 Replies

  • jbwtp's avatar
    jbwtp
    Memorable Member
    3 years ago

    Hi sparvez,

     

    I guess you are questioning this bit?

    Text.Contains([column to look forl],current,Comparer.OrdinalIgnoreCase)

    You can call a column in a table using the name of the column using

    Table.Column(table as table, column as text) as list

     

    Kind regards,

    John 

  • sparvez's avatar
    sparvez
    Helper I
    3 years ago

    jbwtp Super thanks.

    Table.Column(table as table, column as text) as list

     It worked perfectly.