Table name need included on sheet

[#1]

I have 90 excel files all setup the same as below.  I can pull them all in but I need to include the file name with all the data from that file.

It is also in the data but I had to skip the first four rows to get to the data.

Is it possible to link the file name to the data?

[Need to be displayed in app]:

LOAD [Date]

[Reported to PMD Employee:]

[Reported by Facility Employee:]

[Issue Code]

[Issue]

[Details]

[Immediate PMD Action Taken]

[Date2]

[Addt'l Follow Up]

[By PMD Employee]

[Completed on]

[Last Cart Audit Completed]

[House Stock List]

[Materials  / Memo Distributed]

[In-Service Given (List Topic / which shifts given to)]

[Survey Dates and Gap Fill Approved]

[Facility Meeting Attended (List Type - i.e. QA

[Root Cause Analysis]

[Compliments]

[Checked out with DON/ADMIN ( or attempted w/whom)]

FROM [lib://AttachedFiles/Need to be displayed in app.xlsx]

(ooxml embedded labels header is 4 lines table is [Need to be displayed in app]);

[Anonymous]

You could add the file name as a field name

'File Name' as File,

the each row would have a filed that included which file it came from.

[rupamjyotidas]

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

This might help you

[#4]

where do I put this?

[Anonymous · Accepted solution]

Into the script where you are loading the data tables.

[#6]

I loaded this from my data source and tried to pull multiple files in that are Excel.  I did it with TEXT documents and it worked.

What am I doing wrong?

LOAD

    OrderDate,

    OrderNumber,

    FacilityName,

    FacilityID,

    RouteNumber,

    ScheduledLeaveTime,

    ActualLeaveTime

FROM [lib://v2/Runs\/*.xlsx]

(ooxml, embedded labels, table is [xmlRpt(1)]);

[Anonymous]

Is OrderDate spelled like that in the spreadsheet?

[#8]

Yes it is, it loads ok until I change the

FROM [lib://v2/Runs\/*.xlsx]

(ooxml, embedded labels, table is [xmlRpt(1)]);

[Anonymous]

Are you trying to load from multiple spreadsheets at once? I'm not sure that is possible.

[Anonymous]

You may want to post this as a new question, most people won't look at answered questions unless the title indicates it is something they need to know.