Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

ReplaceValue in List.Accumulate

Hello, everyone,   I have problem with my PowerQuery code.   The purpose of the line is to replace space in all rows of each column.   The line is: #"Replaced Value" = List.Accumulate(Table.Co...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    3 years ago

    You could just use:

     

    Table.ReplaceValue(#"Previous Table"," ","",Replacer.ReplaceText,Table.ColumnNames(#"Previous Table"))

     

    If you really want to use List.Accumulate, syntax would be:

     

     List.Accumulate(Table.ColumnNames(#"Previous Table"), #"Previous Table", (state, current)=> 
        Table.ReplaceValue(state," ","",Replacer.ReplaceText,{current}))

     

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
3 years ago

You could just use:

 

Table.ReplaceValue(#"Previous Table"," ","",Replacer.ReplaceText,Table.ColumnNames(#"Previous Table"))

 

If you really want to use List.Accumulate, syntax would be:

 

 List.Accumulate(Table.ColumnNames(#"Previous Table"), #"Previous Table", (state, current)=> 
        Table.ReplaceValue(state," ","",Replacer.ReplaceText,{current}))