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]:|
|[Reported to PMD Employee:]|
|[Reported by Facility Employee:]|
|[Immediate PMD Action Taken]|
|[Addt'l Follow Up]|
|[By PMD Employee]|
|[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]|
|[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]);|
Solved! Go to Solution.
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?
(ooxml, embedded labels, table is [xmlRpt(1)]);
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.