topic Re: Loading Data in Qlikview in QlikView

Loading Data in Qlikview

Anonymous — Mon, 29 Feb 2016 06:41:28 GMT

As i am new to Qlikview i have a doubt.

Consider i have four separate tables of employee details for four months, with same field names.

EmpJaninfo: (Table 1) ( January month - 50 records)

EmpID, Name, GradeLevel, Position, HireDate

001 John 02 abc 01/02/20012

EmpFebinfo: (Table 2) ( February month - 56 records)

EmpID, Name, GradeLevel, Position, HireDate

001 John 02 abc 01/02/20012

EmpMarinfo: (Table 3) ( March month - 60 records)

EmpID, Name, GradeLevel, Position, HireDate

001 John 03 xyz 01/02/20012

EmpAprinfo: (Table 4) ( April month - 66 records)

EmpID, Name, GradeLevel, Position, HireDate

001 John 03 xyz 01/02/20012

In this case, how do i load these tables in qlikview and will form a association with each other.?

And how do i differentiate these 4tables belongs to this particular month.?

Re: Loading Data in Qlikview

sunny_talwar — Mon, 29 Feb 2016 20:48:11 GMT

I would concatenate the four tables to form a single fact table:

Table:

LOAD EmpID,

Name,

GradeLevel,

Position,

HireDate

FROM SourceFileJan;

Concatenate (Table)

LOAD EmpID,

Name,

GradeLevel,

Position,

HireDate

FROM SourceFileFeb;

If the source is Excel, there might be an even simpler way to do this.

Re: Loading Data in Qlikview

tschullo — Mon, 29 Feb 2016 20:51:46 GMT

You could load them all in sequence and QlikView will concatenate them into the same table:

LOAD

EmpID, Name, GradeLevel, Position, HireDate,

'January' as Month From Jan.xlx ....

LOAD

EmpID, Name, GradeLevel, Position, HireDate,

'February' as Month From Feb.xlx ....

LOAD

EmpID, Name, GradeLevel, Position, HireDate,

'March' as Month From Mar.xlx ....

LOAD

EmpID, Name, GradeLevel, Position, HireDate,

'April' as Month From Apr.xlx ....

Re: Loading Data in Qlikview

tschullo — Mon, 29 Feb 2016 21:10:27 GMT

It would be better to create a DATE type field for Month.

You could for instance load it as:

MakeDate(2016,1) as Month // this will be equivalent to Jan 1, 2016 but you can format it to display as Month only.

Re: Loading Data in Qlikview

MarcoWedel — Mon, 29 Feb 2016 23:29:07 GMT

Hi,

what's your data source?

If there are multiple files having months as file name, you could e.g. load them like

LOAD *,

FileBaseName() as Month

FROM *.xxx (...);

QlikView would auto concatenate them in this case and add a month field.

please post some sample to demonstrate.

hope this helps

regards

Marco

Re: Loading Data in Qlikview

ramasaisaksoft — Tue, 01 Mar 2016 05:55:11 GMT

Hi Kishore,

My choice is

-->Concatenate

-->use Qualify * and Un qualify single column

Re: Loading Data in Qlikview

Digvijay_Singh — Tue, 01 Mar 2016 06:08:05 GMT

You need to add new field to identify the month to differentiate records.

As MarcoWedel‌ suggested , see if you can get month name from the filename. You can use string functions to extract it in case filename is not exactly reflecting month name. Also try to include year component also in this new field else next year you might have duplicate records with same month.

Re: Loading Data in Qlikview

saniyask — Tue, 01 Mar 2016 06:10:07 GMT

Hi,

If the table structure is same it will auto concate all the tables, nothing much too do ..

If you have same field name and same sort of values in your table let it auto concate so you have a single table instead of three..

You can create a master calendar on your date field..

Regards,

Saniya Shaikh..