data model

[deepakqlikview_123]

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,

[ashfaq_haseeb]

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

[its_anandrjs · Accepted solution]

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);

[Joseph_Musekura]

Hi,

In addition to above suggestions, please check this link:

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

Regards