Qlik Community

QlikView Connectors

Discussion board for collaboration related to QlikView Connectors.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

QlikView SAP SQL Connector: problem with inner join

Hi,

I’m trying to query the corresponding records between SAP tables CDHDR and AUSP as part of performing a delta load by using the Qlik SAP SQL Connector (version 6.3.2).

In theory it’s simple: one of the key fields of CDHDR (OBJECTID) should be the same as OBJEK in table AUSP. The inner join isn't the problem but I got stuck on a apparently simple problem. All values in CDHDR.OBJECTID ends with an ‘O’, while all values in AUSP.OBJEK are numeric (like 1234O in CDHDR.OBJECTID vs. 1234 AUSP.OBJEK). The solution seems simple: get rid of the ‘O’ in CDHDR.OBJECTID or add the ‘O’ to AUSP.OBJEK.


I tried various SQL functions like ‘+’, LEFT, etc… The Qlik SAP Connector won’t recognize these functions and keeps aborting.

Do you know how to solve this?

Cheers,

Michiel

0 Replies