topic Re: Re: Data Model Issue in QlikView

Data Model Issue

ankurakash — Mon, 22 Sep 2014 23:30:45 GMT

Hi,

I have created a data model for which I sought your opinion and solution. Snapshot is posted below.

I have to add additional two tables to the data model. The issue is: if I add these tables it has common fields and will create synthetic key.

Sharing the structure of two tables:

1) Web_Auth

2) Web_Staging

Structure of both tables mentioned below:

//Web_Auth:
//LOAD TAX_PAYER_NO,
// USERID,
// CREATE_DATE (Required field - Date filter required.)
//FROM
//[..\Data\QVD\Web_Auth.QVD]
//(qvd);
//

2. //Web_Staging:
//LOAD // E_FILE_NO,
//    TAX_TYPE_NO,   (required field)
//   TAX_PAYER_NO, (required field)
//   CREATED_DATE, (required field)

//[..\Data\QVD\Web_Staging.QVD]
//(qvd);
//

I think linking would be a solution but I am not getting close to the solution. It would be of great help if QlikView Experts can guide me through steps that I need to take to include the above tables in the data model.

Regards,

Ankur Akash

Re: Data Model Issue

Siva_Sankar — Tue, 23 Sep 2014 06:49:11 GMT

Ankur,

I didnt see a synthetic key in your data model. Can you share your qlikview file once after loading all data?

Re: Data Model Issue

PrashantSangle — Tue, 23 Sep 2014 07:00:44 GMT

Hi,

Just Key create Key Field by combining those field which gives you unique data.

and Rename other field which is required but created Synthetic Keys.

Regards

Re: Data Model Issue

ankurakash — Tue, 23 Sep 2014 14:53:32 GMT

Attached is the data model

Re: Re: Data Model Issue

Siva_Sankar — Wed, 24 Sep 2014 02:20:01 GMT

Ankur,

Follow the steps in the attached document. I dont have the clarity of data from the screenshot.