none
Dealing with folders where not all files have headers RRS feed

  • Question

  • I am extracting files from a folder, but i have an issue. Even though the files has the same structure, some of then doesn't have headers.

    What approach can i use to read the files and add the headers when there aren't, and leave intact those which have them in  massive way?

    Thursday, July 19, 2018 3:47 AM

Answers

  • Yes they all have the same structure, however i just found a practical way (i am a dumb). Just don't promote headers in the sample file transformation and get rid of them in the transformation file.
    Sunday, July 29, 2018 8:37 AM

All replies

  • Are the headers of the files (who have them) all the same?

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Sunday, July 29, 2018 8:12 AM
    Moderator
  • Yes they all have the same structure, however i just found a practical way (i am a dumb). Just don't promote headers in the sample file transformation and get rid of them in the transformation file.
    Sunday, July 29, 2018 8:37 AM