Forum Discussion
Solved
Column not populating
Hello Community, I have a dataset which utlizies CSV files as their data source. The table consisits of 5 columns and one custom column which translates the date into the start of month. The form...
- Are the first 6 and last 4 spend column names exactly the same?
Does the Spend column still exist? If not, it will show nulls once you append/combine them. If there is an extra column, and you have the number of columns specified in the source function (like [Columns = 6]) then you wont pick up any new columns.
I bet that if you remove the columns parameter from the Csv.Document, everything will fall into place.
--Nate