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"))

KCinMelbourne's avatar
KCinMelbourne
Icon for Resolver I rankResolver I
7 years ago
Thanks. If that's the case, is there a way to use 'try' or similar so that if it tries to replace values in a column and then that column doesn't exist (as it has been deleted), it will skip that column and proceed with the next? Cheers KC
sckienle's avatar
sckienle
Icon for Advocate II rankAdvocate II
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"))

  • philipblondewwt's avatar
    philipblondewwt
    New Member
    7 years ago

    This solution works and resolves replacing values in columns that can have changing names.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Excellent re whole table thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Champion! Thanks.

  • HelpWanted's avatar
    HelpWanted
    Regular Visitor
    3 years ago

    This is great!

    Is it possible to only apply this to columns of type text? I have date and currency columns I would need to bypass.

    • sckienle's avatar
      sckienle
      Icon for Advocate II rankAdvocate II
      3 years ago

      You should be able to use the Table.ColumnsOfType function in place of the Table.Column to limit the list returned to only columns of a specific type.

  • kaitlyndunn's avatar
    kaitlyndunn
    Regular Visitor
    1 year ago

    this was EXACTLY what i needed - thank you so much