topic Re: data model in QlikView

data model

deepakqlikview_123 — Tue, 06 May 2014 09:45:04 GMT

Hi All,

Please find attached QVW file.

I want to join Rep_MisBRC_Vehicle_Mapping table to Ves_Vehicle_Master by using Vehicle ID.

I want to retrieve all records from table Ves_Vehicle_Master.I also want to remove all synthetic keys

Can u please suggest what would be good data model for this.

Thanks,

Re: data model

ashfaq_haseeb — Tue, 06 May 2014 09:51:05 GMT

Hi,

Try below

VES_VehicleMaster:

LOAD VehicleID,

VehiclePartNumber,

ModelID,

ModelTypeID,

VehicleShortDescription,

VehicleDescription,

ClassOfVehicle,

HorsePower,

FuelUsed,

NumberOfCylinders,

SeatingCapacity,

UnladenWeight,

AxleWeight,

AnyOtherAxle,

FrontAxle,

RearAxle,

TandemAxle,

GrossWeight,

DealerTypeID,

IsGearBoxApplicable,

FactoryModelCode,

IsDeleted,

CreatedBy,

CreatedOn,

UpdatedBy,

UpdatedOn,

IsMigratedData,

EBSReportID,

EBSReportDescription,

IsIDMSMigratedData,

IsAvailableForApePariwar,

IsInActive

FROM

(qvd);

left join(VES_VehicleMaster)

LOAD VehicleType,

ModelTypeDescription,

ModelHead,

MainHead_OneTwo,

SubHead_OneTwo,

SubMainHead_ThreeLast,

SubHead_ThreeLast,

//VehiclePartNumber,

//VehicleShortDescription,

RegionwiseGroup,

RegionwiseSubGroup,

Sequence,

FuelGroup,

VehicleID

FROM

(qvd);

Regards

ASHFAQ

Re: data model

its_anandrjs — Tue, 06 May 2014 11:23:44 GMT

On the base of the VehicleID you can join this two tables and for avoiding the synthetic keys rename the fields or remove it from the tables see the script keep your master table upside and left join

LOAD VehicleID,

VehiclePartNumber,

ModelID,

ModelTypeID,

VehicleShortDescription,

VehicleDescription,

ClassOfVehicle,

HorsePower,

FuelUsed,

NumberOfCylinders,

SeatingCapacity,

UnladenWeight,

AxleWeight,

AnyOtherAxle,

FrontAxle,

RearAxle,

TandemAxle,

GrossWeight,

DealerTypeID,

IsGearBoxApplicable,

FactoryModelCode,

IsDeleted,

CreatedBy,

CreatedOn,

UpdatedBy,

UpdatedOn,

IsMigratedData,

EBSReportID,

EBSReportDescription,

IsIDMSMigratedData,

IsAvailableForApePariwar,

IsInActive

FROM

(qvd);

Left Join

LOAD VehicleType,

ModelTypeDescription,

ModelHead,

MainHead_OneTwo,

SubHead_OneTwo,

SubMainHead_ThreeLast,

SubHead_ThreeLast,

VehiclePartNumber as Vehical_PartNumber,

VehicleShortDescription as Vehicle_ShortDescription,

RegionwiseGroup,

RegionwiseSubGroup,

Sequence,

FuelGroup,

VehicleID

FROM

(qvd);

Re: data model

Joseph_Musekura — Tue, 06 May 2014 11:31:51 GMT

Hi,

In addition to above suggestions, please check this link:

http://community.qlik.com/thread/39177

Regards