Forum Discussion

jlpa's avatar
jlpa
Regular Visitor
8 years ago
Solved

Load data from txt tab separated file

Hello,   I am trying to load 2 txt files with same format. As you see i have columns Name and Path in both files.     File1-below Name Path test.txt c:\local\test.txt test6.txt c:\local\test6...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi jlpa,

     

    When we use get data from Files, this structure is created:

     

     

    You have to select the table Transform Sample File form <FolderName> and  apply Use First Row as Headers to that table:

     

    And this modifies the final table and solves the problem you're having.

     

    Note: You must delete the last step Changed Type because the name of the columns will not match, due to the Promote Headers that we apply,

     

    Regards.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi jlpa,

 

When we use get data from Files, this structure is created:

 

 

You have to select the table Transform Sample File form <FolderName> and  apply Use First Row as Headers to that table:

 

And this modifies the final table and solves the problem you're having.

 

Note: You must delete the last step Changed Type because the name of the columns will not match, due to the Promote Headers that we apply,

 

Regards.

jlpa's avatar
jlpa
Regular Visitor
8 years ago

Hello Felipe,

 

Solved. Thank for your help :)