Unanswered

including filename in upload

(0) Share

Report

Posted on by ItisOK

Hi guys,

hope I am at the right place here. I need to upload multiple excel files from a folder. Besides all the columns of all the excel files, I need to be the filename to be included as well. The relevant code up to now is:

Source = Folder.Files(FolderpathFacts),
#"Added Custom" = Table.AddColumn(Source, "Custom", each fnGetFacts([Folder Path]&[Name])),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Filename", "Custom"}),
ImportAllColumns = #"Removed Other Columns"[Custom],
Custom1 = Table.Combine( ImportAllColumns),

"Filename" is not included in the imported columns.

Who can help me out?

All responses (2)

Answers (0)

ItisOK 2 on at

Like (0)

Report

Re: including filename in upload

Hi Mandela,
Thank you for pointing out the link to the video. Uploading multiple files is not the issue. That is taken care of in the fnGetFacts function. My current code uploads all excel files, and all columns of those files. in a later step, based on a list, all non-wanted columns are removed. I think there is the basis of the problem. The code imports all columns defined in "custom", but not the filenames.
Akah Mandela 445 on at

Like (0)

Report

Re: including filename in upload

Check out this Video tutorial i think it will help you sort out your issue