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: 
Anonymous
Not applicable

Loading Data in Qlikview

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.?


7 Replies
sunny_talwar

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.

tschullo
Creator III
Creator III

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 ....

tschullo
Creator III
Creator III

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.

MarcoWedel

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

ramasaisaksoft

Hi Kishore,

My choice is

-->Concatenate

-->use Qualify * and Un qualify single column

Digvijay_Singh

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.

saniyask
Creator
Creator

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..