Forum Discussion
Replace Value if Column exists
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
Helper IAs 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
Thank you, I will think about the suggestion. I agree to either back out, or ignore the ditch.
Here is some context.
I want to migrate ten columns (old list) and collapse them into two columns (new list). Yet the multiple sources may vary in the number of columns (old list). For each column, I pivot the data to two columns: Old List or New List. Then I do the compare between old and new lists.
My goal was to set up an audit for this tedious process. There are three desired states to track:
1) just starting (only old list)
2) migrated columns (old list and new list)
3) remove old list columns (only new list)
This is the reason I was trying to define conditions on whether a column exists or not.