Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]); |
Into the script where you are loading the data tables.
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.
where do I put this?
Into the script where you are loading the data tables.
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)]);
Is OrderDate spelled like that in the spreadsheet?
Yes it is, it loads ok until I change the
FROM [lib://v2/Runs\/*.xlsx] |
(ooxml, embedded labels, table is [xmlRpt(1)]); |
Are you trying to load from multiple spreadsheets at once? I'm not sure that is possible.
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.