Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

When i remove file from folder , i get error msg

Hi All

I am using folder load , i notice that when i remove some of file from folder during testing stage , i get loading error , it there a way to solve it ? As during testing stage i just want to test one file , once success then i add more file to test. Hope some one can share with me :-

 

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    The error message tells you that in the date_t column some rows are empty and this is not allowed for the reasons stated in the error message.

    Fix those errors in the source files - make sure you don't have any empty rows in date_t.

    Phil

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Anonymous 

    The error message tells you that in the date_t column some rows are empty and this is not allowed for the reasons stated in the error message.

    Fix those errors in the source files - make sure you don't have any empty rows in date_t.

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Phil

      This will save me a lot of time. Thank you.

      Paul

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous -If you are testing it, I think in your power query , you can do remove blank rows from Target table. 

    As the error says it'snot allowed incase of many to many relationship.

    OR, you can look for changing relationship criteria.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Sir

      May i know how to remove below error ?