I have a PQ that collates multiple excel spreadsheets and cleans the data up for use. There have been a couple of times where one of the column headers has an * at the end of the column name. This blows up the query. I know that PQ does not support wildcards, is there another solution to account for a column sometimes having a * so that I do not have to go into the file and delete it?
Thank you!
Hi Lisa,
I wonder if it's less about the asterisk and more about it simply having a different name than what Power Query is expecting. You could test it by placing a number or another letter at the end of the column name in place of the asterisk to see if it causes the same problem. If so, this tutorial may be of help.
Mynda
Thank you so much, I will try that. you are right, it is not the * but that the column is different.
