Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table name need included on sheet

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]);
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Into the script where you are loading the data tables.

View solution in original post

10 Replies
Anonymous
Not applicable
Author

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.

Not applicable
Author

where do I put this?

Anonymous
Not applicable
Author

Into the script where you are loading the data tables.

Not applicable
Author

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
Not applicable
Author

Is OrderDate spelled like that in the spreadsheet?

Not applicable
Author

Yes it is, it loads ok until I change the

   

FROM [lib://v2/Runs\/*.xlsx]
(ooxml, embedded labels, table is [xmlRpt(1)]);

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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.