Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to get some data out of an database. However, the load script does give an error in Qlik. When I run the SQL statement in the database, there occurs no error.
See below the error and the SQL statement.
Select
a.FK_BUDGETORDERINTAKEYEAR,
a.BUDGET,
a.MARGE,
a.BUDGETPRODUCTION,
a.PK_U_BUDGETORDERCATEGORY,
a.FK_BUDGETORDERCATEGORY,
a.FK_BUDGETSERVICECONTRACTTYPE,
a.INVOICEORDERINTAKE,
b.PK_R_ORDER,
b.FK_ORDERCATEGORY,
c.PK_R_SALESORDERDETAILMISC,
c.NETSALESAMOUNT,
c.ORDERDATE,
//c.FK_SALESPERSON,
d.FK_FINANCIALYEAR,
d.PRODUCTIONPERCENTAGE
FROM U_BUDGETORDERCATEGORY a
LEFT JOIN R_ORDER b ON a.FK_BUDGETORDERCATEGORY = b.FK_ORDERCATEGORY
LEFT JOIN V_R_SALESORDERDETAILMISC c ON b.PK_R_ORDER = c.FK_ORDER
LEFT JOIN U_PRODUCTION d ON c.PK_R_SALESORDERDETAILMISC = d.FK_SALESORDERDETAILMISC;
Hi,
In your screenshot, FK_ORDERCATEGORY comes from c (U_BUDGETORDERCATEGORY maybe, cannot see because truncate) table, but in the SQL request you've shared, it's come from R_ORDER b.
Maybe the problem is here ?
Regards
Hi,
Qlik messes up the truncate columns, as you can see in the screenshot and the SQL statement. I did try to copy the data in a new app, but then I get a simular error. Now, how to fix this?
Regards en help is much appreciated
Your screenshot and the shown sql-script are not the same - make sure that you don't mix up things.
Beside this your error isn't caused from Qlik else it's an error-message from the data-base.