Discussion Board for collaboration on QlikView Scripting.
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:
Structure of both tables mentioned below:
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.
I didnt see a synthetic key in your data model. Can you share your qlikview file once after loading all data?
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.
Attached is the data model
Follow the steps in the attached document. I dont have the clarity of data from the screenshot.