Loading Data in Qlikview

[Anonymous]

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

[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]

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]

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]

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