Forum Discussion

KCinMelbourne's avatar
KCinMelbourne
Icon for Resolver I rankResolver I
7 years ago
Solved

Replace Value in Whole Table

Hi guys,   I've had issue in the past where Project Online data pulls in with 'non printable characters'. It's a pain because it appears as a space but when you try to (for example) merge the table...
Need Help
  • sckienle's avatar
    sckienle
    7 years ago

    You can do this by using the Table.ColumnNames function in replacement of the specific column list.  E.G. Table.ReplaceValue(#"Last Step",null,"-",Replacer.ReplaceValue,Table.ColumnNames(#"Last Step"))

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi KCinMelbourne

 

I'm afraid there's no better way to achive that. I would suggest you modify or add steps in query editor to replace the values in whole table.

 

Regars,

Cherie

Bella42's avatar
Bella42
Icon for Advocate IV rankAdvocate IV
4 years ago

Maybe you should avoid saying 'there is NO better way to achieve this' unless you are absolutely sure. Clearly, looking at the solution, there is a better way, and exactly what was asked for (using Table.Columns with the name of the previous step). Luckily I didn't just read your answer and give up...I am only saying this as it says you are an 'employee' of Microsoft, so people will take what you say seriously, and in this case it is seriously wrong, despite your assurances...no offence meant, but try not to be so adamant, unless you are absolutely sure.