Forum Discussion
Adding a column
You should check the steps here one by one and determine in which step your columns disappeared. If you still can't see the column you added in the source step, there is a problem with your refresh or delimiter.
Best regards,
Ezgi Naz Aslankara
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
It never disappeared. I didn't have it in the original .csv when I created the table. I clicked get data, from csv, pointed to the file path and file, clicked okay, Power Query Opened and I did my transformation work. All good. The thing is, I didn't have the column in the csv that I am now trying to add to the table. It never did disappear because it wasn't there in the first place.
To put it another way, I subscribe to a real estate data service. The service permits people to create custom downloads. You pick the fields you want, save it, and then when you're working a new project and need new data, you make the query and download. When I setup the download, I missed/forgot a column. This is why it's not in the table.
I've edited the download from the service to include one new column or field. I can see it when I open the csv in Excel or Notepad.
When I try and refresh, it doesn't get added to the table.
I've tried the step where:
and add it via inserting the code which in this case is , {"Public Remarks", type text}, but I get a message it didn't find it in the table.
In the desktop DataView I've tried to add a column, and It works, but it doesn't show in Query Editor.
There has to be a way to add a field from the csv.