Forum Discussion
Replace Value if Column exists
I have a query that typically has two columns: "New List" and "Old List." I used the Replacer.ReplaceValue to fix null values. The issue is that sometimes the query may not have the "New List" c...
As an alternative, you could try configuring it differently. And note, this may fail completely, I don't have a similar situation to try it with readily avialable.
In the table, in power query editor, create a new column, then set up a formula to make that column pull in values from a column by the name but if it fails, pull in nothing.
Then do the replacevalue on the values in that column, that way the column always exists and doesn't trigger that error.
This may not work as the means of filling the column with the occasionaly nonexistent column may trigger that same error message, but if you use an if else statement, or iferror statement, it should theoretically work....
Hope that helps
Ahmedx
Super User
Super Userpls try this
= Table.ReplaceValue(#"previousStep",null,null,(x,y,z)=>if x =null then "" else x,List.Select( Table.ColumnNames(#"previousStep"), (x)=> x ="New List"))