Forum

The file does not l...
 
Notifications
Clear all

The file does not load the data - why?

4 Posts
2 Users
0 Reactions
156 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Hi,
Thanks for the help!
I have here 2 files that I am merging with a folder
The problem is that after the merge - in the After file - in the Part Number column
Data disappears - in rows obtained from the PCB-120-007 file
He just does not load the data
Why??

 
Posted : 23/11/2021 2:52 am
(@debaser)
Posts: 837
Member Moderator
 

The data in the second workbook doesn't have the same headers in row1, which means that your query to load the data doesn't produce the same headers as it does for the first file. That's why all the columns end up as null.

 
Posted : 23/11/2021 4:39 am
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Thanks for the quick reply!!
I accidentally uploaded an invalid file
France here the 2 original original files

Thanks for the answer in advance !!
Leah

 
Posted : 23/11/2021 4:45 am
(@debaser)
Posts: 837
Member Moderator
 

That one works fine for me (other than the missing Value column).

 
Posted : 23/11/2021 5:23 am
Share: