Uploading files to a file table - help -

Power Query

Last Post by Riny van Eekelen 3 years ago

2 Posts

2 Users

0 Reactions

81 Views

RSS

Moshe Arama

(@moshe_arama)

Posts: 14

Eminent Member

Topic starter

Hi QUESTION :

I made a folder when i put her a file the table updating,

the first one upload great but when I insert another file with the same structure but his header doesn't remove like the first file why it's happening ??

Posted : 05/09/2022 1:12 am

Riny van Eekelen

(@riny)

Posts: 1193

Member Moderator

Hi Moshe,

Make sure that the step to promote the header is in the query for the "Transformation Sample File". Then every new file added to the folder will have its headers promoted before combining it with the others. That way, the headers will not repeat in the combined file.

Riny

Posted : 05/09/2022 2:46 am

26 Forums
7,242 Topics
31.8 K Posts
9 Online
35.2 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Uploading files to a file table - help -

Super Globals

Options and Features