Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Combine files (Binary) Missing rows

Hi All,

 

I'm having problems with the Combine Files (Binary) feature, I'm trying to combine 3 files with the same column structure and 200 lines long each. Once I apply the feature of combine them, just two of them are shown complete (200 lines each) but the third one just bring me up 10 lines, so I end up with a table of 600 records instead of 600. Has anyone seen this before? The transformation steps are happening in the Transform Sample File.

 

The way I temporary fix it is getting into the file that isn't showing all the records and edit a cell (any cell) undo it and save it back. With this, I just refresh the query with the combined files and now it showing me the complete 600 rows. Is like if I need to "activate" the workbook that isn't working. 

 

Am I doing something wrong?

 

Thanks!

3 Replies