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?

Categories:

Power Query

I have the same question (0)

All responses (2)

Answers (0)

Akah Mandela 445 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ItisOK 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No