Check for the existence of one of two columns, and select the one that does exist?

[mikemck]

I have a series of query's that are set up to select a specific column, but now that column has changed. This of course broke pretty much every report I was generating with these queries.

What I need to do is check for the existence of one of two columns, and select the one that does exist

In my case, the two columns name are WO number or WO ID.

Any help would be greatly appreciated.

 

[Bob Phillips]

You could use try error handling

Table.AddColumn(Source, "Custom", each try [WO] otherwise [WO ID])

 

[mikemck]

Ah, I'll try that. Thank you very much indeed.