topic Re: Qlik Sense Resident Table Load not Working in QlikView

Qlik Sense Resident Table Load not Working

MalcolmCICWF — Thu, 03 Dec 2015 17:45:16 GMT

I am running into an issues that I am having a problem figuring out. I am loading a table in script from and Excel file and then trying to create a secondtable where I will do some other data manipulation, but this second table will not load. After loading the data, only the first table exists. Am I doing something wrong? I have done this many times in Qlikview, is there a bug in Qlik Sense?

[TableImport]:
LOAD
[Status],
[Location],
[Created By(Name)] as CreatedBy,
[Ticket #] as TicketNum,
[Summary],
     Date(Timestamp#([Create Date],'YYYY-MM-DD @ hh:mm TT')) as CreateDate,
     Time(Timestamp#([Create Date],'YYYY-MM-DD @ hh:mm TT')) as CreateTime,
[Close Date],
[Assigned to],
[Request Type],
[Categorization]

FROM [lib://Apps/ServiceDesk.xlsx]
(ooxml, embedded labels, table is [Spiceworks Report]);

[ServiceDesk]:
LOAD
[Status],
[Location],
CreatedBy,
TicketNum,
[Summary],
     CreateDate,
     CreateTime,
[Close Date],
[Assigned to],
[Request Type],
[Categorization]

Resident TableImport;

// Drop table TableImport;

Re: Qlik Sense Resident Table Load not Working

satishkurra — Thu, 03 Dec 2015 17:57:16 GMT

I don't see any problem here...

If you can put the error screen shot it will be helpful to understand much better

Re: Qlik Sense Resident Table Load not Working

maxgro — Thu, 03 Dec 2015 18:01:00 GMT

If the 2 tables have the same number and names of fields Qlik will concatenate (like a SQL union all) the tables and you get all records in first one

Add a noconcatenate to the second one.

[ServiceDesk]:

noconcatenate

LOAD

....

Re: Qlik Sense Resident Table Load not Working

JonnyPoole — Thu, 03 Dec 2015 18:21:20 GMT

They seem to be loading the same kind of data because all the columns are the same. Maybe you want this ?

If so, you can differentiate the records by adding a new field with a different constant value for each load. Then you can slice the data sets by this new field 'Source' with values of your choice (in my ex below file1, file2)

[TableImport]:
LOAD

'File1' as Source,
[Status],
[Location],
[Created By(Name)] as CreatedBy,
[Ticket #] as TicketNum,
[Summary],
     Date(Timestamp#([Create Date],'YYYY-MM-DD @ hh:mm TT')) as CreateDate,
     Time(Timestamp#([Create Date],'YYYY-MM-DD @ hh:mm TT')) as CreateTime,
[Close Date],
[Assigned to],
[Request Type],
[Categorization]

FROM [lib://Apps/ServiceDesk.xlsx]
(ooxml, embedded labels, table is [Spiceworks Report]);

[ServiceDesk]:
LOAD

'File2' as Source,
[Status],
[Location],
CreatedBy,
TicketNum,
[Summary],
     CreateDate,
     CreateTime,
[Close Date],
[Assigned to],
[Request Type],
[Categorization]

Resident TableImport;

// Drop table TableImport;

Re: Qlik Sense Resident Table Load not Working

MalcolmCICWF — Thu, 03 Dec 2015 19:26:56 GMT

I guess I never had this issue in QlikView. I plan on adding some fields based on calculations, but I was just testing and noticed they were combining into 1 table.

Re: Qlik Sense Resident Table Load not Working

maxgro — Thu, 03 Dec 2015 19:48:11 GMT

not an issue, it's by design

automatic concat for same number and names of fields

concatenate to force concat also for different number and/or names

noconcatenate to force no concat

Re: Qlik Sense Resident Table Load not Working

MalcolmCICWF — Thu, 03 Dec 2015 20:19:07 GMT

Well this seemed to work, I guess I just never ran into this before Qlik Sense. Typically if I created a second table referencing some/all the fields, then dropped the first table, the second one would be left. This makes it look as if ignored the drop table statement.

Either way, the NoConcatenate seems to have worked here