Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Accepted Solutions
bellamae
Valued Contributor

Re: Table name need included on sheet

Into the script where you are loading the data tables.

10 Replies
bellamae
Valued Contributor

Re: Table name need included on sheet

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
Valued Contributor

Re: Table name need included on sheet

Not applicable

Re: Table name need included on sheet

where do I put this?

bellamae
Valued Contributor

Re: Table name need included on sheet

Into the script where you are loading the data tables.

Not applicable

Re: Table name need included on sheet

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

bellamae
Valued Contributor

Re: Table name need included on sheet

Is OrderDate spelled like that in the spreadsheet?

Not applicable

Re: Table name need included on sheet

Yes it is, it loads ok until I change the

   

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

bellamae
Valued Contributor

Re: Table name need included on sheet

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

bellamae
Valued Contributor

Re: Table name need included on sheet

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.