Forum Discussion

Ricsa's avatar
Ricsa
New Member
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi 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.

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi 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.