Forum Discussion
Solved
Importing text as null from excel worksheet
Hi all, My report is being monthly actualized with information i gather from different sources into one excel database. I didn´t have any problems before but for this month it is importing a colu...
Consider that two of your Excek columns have the same name (Form.Prod). I bet your M code is looking for a different column name, instead finding the wrong name, and therefore making these values null.
--NateHi Ricsa ,
Are the names of the two columns I circled the same? Please try to change to a different column name.
You can clear the data source in the datasource settings and reconnect it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Consider that two of your Excek columns have the same name (Form.Prod). I bet your M code is looking for a different column name, instead finding the wrong name, and therefore making these values null.
--Nate