How do I get rid of $Syn table

[#1]

Hello,

I am a newbie to Qlikview and am trying to create my own report for the first time. Unfortunately I am running into some issues with a $Syn table.

My scenario: I have a table with "processed hour" records. Such a record contains an hourcode and a ProdHeaderDossierCode. I also have a HourBudgetTranslate table which translates the hourcode to an hourbudgetcode based on the HourCode, unless a ProdHeaderDossierCode or DossierCode exists in the HourBudgetTranslate table, then it should translate to the related hourbudgetcode. Since the DossierCode is not part of the ProcessedHour table, I also have to link to another table to retrieve the dossiercode based on the ProdHeaderDossierCode. So now I have 3 fields that end up in the $Syn table (DossierCode, HourCode and ProdHeaderDossierCode).

I don't think renaming works since the HourBudgetTranslate table translates based on the actual codes.

Can anyone help me out and point me in the right direction?

Kind regards,

Diego

[gajapathy74]

am not able to validate this, pls give a try. modify the script for HourBudgetTransLate and ProcessedHour tables as shown below.

//***HourBudgetTranslate***

HourBudgetTransLate:

Load HourBudgetCode,

HourCode,

DossierCode,

ProdHeaderDossierCode,

HourCode + '--' + ProdHeaderDossierCode as HourCodeProdHeadDossierCode;

SQL SELECT *

FROM TestProduktieDB.dbo.CH_HourBudgetTranslate;

//***ProcessedHour***

ProcessedHour:

Load

//ProdHeaderDossierCode,

RegDate,

Month(RegDate),

Year(RegDate),

Week(RegDate),

EmpId,

MachGrpCode,

//HourCode,

HourCode + '--' + ProdHeaderDossierCode as HourCodeProdHeadDossierCode,

(CalculatedTotalTime/3600)/8 AS '[TotalTime in days]',

CalculatedTotalTime/3600 AS '[TotalTime in hours]';

SQL SELECT *

FROM TestProduktieDB.dbo.T_ProcessedHour;