Forum Discussion
Solved
One data column not refreshing, but not getting any error messages
My model has been pulling data from excel files that upload to a folder monthly. Never had any problems. That data flows into a table that merges with another table to form the query I use for modeli...
Check in the import queries that your column hasn't become lost somewhere. Given that you are using Excel files, its possible something has occured that has caused your column to become excluded. Some examples might be:
- One of your initial files is CSV and only looks for X columns but your column is a now X + 1
- The column you care about has had a name change, even if its a blank character added, and is now being missed or excluded by a join or a remove other columns.
Check in the import queries that your column hasn't become lost somewhere. Given that you are using Excel files, its possible something has occured that has caused your column to become excluded. Some examples might be:
- One of your initial files is CSV and only looks for X columns but your column is a now X + 1
- The column you care about has had a name change, even if its a blank character added, and is now being missed or excluded by a join or a remove other columns.