I have following problem. I have data sources of 2 different types: SQL Server and progress database. The problem is that when I try to make joining fields based on the excatly same name, QlikView changes progress database's filed names to upper case and then the joining fails between the tables.
Below is simple example what I'm trying to do. I noticed that I had the same problem with some Excel-files. I know that I could solve this problem by changing the SQL Server fields to uppercase with AS word but I have already made a lot with only the SQL Server data and I would need to correct loads of objects in my QlikView file if I would change the field names.
Hopefully somebody knows what is the issue in here.
EXAMPLE (PROD is SQL Server and POW is progress db):
CONNECT32TO PROD (XUserIdis ***, XPasswordis **);
(DCustName & ' / ' & Text(DCustNum)) ASDCustomer;
SQL SELECT CustName AS DCustName,
CustNum AS DCustNum,
Item AS DItemCode
CONNECT32TO POW (XUserIdis **, XPasswordis **);
SQL SELECT CtrlType as ITCtrlType,
ItemCode as DItemCode,
ItemName as ITItemName
-->The result is that ACS_Main fields will be in table view exactly like stated (DCustName, DCustNum, Factory, DItemCode) but PUB.Item fiels are in uppercase (ITCTRLTYPE, DITEMCODE,ITITEMNAME)
I would like to link the tables based on the DItemCode