Performing a join on data load from Oracle and Salesforce

bobbyn4u — Wed, 09 May 2018 19:22:29 GMT

Hello Everyone ;

I'm trying to load two tables into a Qliksense script editor and perform a join. I normally do this with two SQL tables and have no issues doing so. However, the new table I'm loading is coming from Oracle and I'm having trouble with the syntax for this Qliksense.

can anyone kindly help me with the correct syntax?

Below is the script:

LIB CONNECT TO 'Salesforce_BULK';

[SFDC_Account]:

LOAD Id,

Name,

D_U_N_S__c,

text(CDH_Party_Number__c) as partynumber ;

SELECT Id,

Name,

D_U_N_S__c,

CDH_Party_Number__c

FROM Account where Id in('0016000001B32mCAAR','0016000001MfwSPAAZ');

Store [SFDC_Account] into APAC_SFDC2.qvd;

Drop Table [SFDC_Account];

LIB CONNECT TO 'Oracle_cdh.corp.xyz.com';

LOAD PARTY_ID,

text(PARTY_NUMBER) as partynumber,

PARTY_NAME,

(DUNS_NUMBER_C) ;

[HZ_PARTIES]:

SELECT "PARTY_ID",

"PARTY_NUMBER",

"PARTY_NAME",

"DUNS_NUMBER",

"DUNS_NUMBER_C"

FROM "AR"."HZ_PARTIES" where PARTY_NUMBER in('8064508','20282');;

Store [HZ_PARTIES] into APAC_CDH2.qvd;

Drop Table [HZ_PARTIES];

// Audit_Data:

Load partynumber, D_U_N_S__c from APAC_SFDC2.qvd (qvd);

Keep

load partynumber,DUNS_NUMBER_C from APAC_CDH2.qvd (qvd);

Output:

partynumber	DUNS_NUMBER_C	D_U_N_S__c
-	-	694346883
8064508	694346883	-
20282	-	-

Correct output should be like below:

partynumber	DUNS_NUMBER_C	D_U_N_S__c
8064508	694346883	694346883
20282	-	-

Message was edited by: lakshminarayana Palla

Re: Performing a join on data load from Oracle and Salesforce

vamsee — Wed, 09 May 2018 19:47:26 GMT

Hello,

I think its coz, your table name has to be above the load statement.

Hence the data format of partynumber is dual in the second table (HZ_PARTIES).

As you see D_U_N_S_c does not have a party number linked to it.

Please share your sample app.

Regards

Vamsee

Re: Performing a join on data load from Oracle and Salesforce

bobbyn4u — Thu, 10 May 2018 03:11:08 GMT

Hi Vamsee,

I am getting the table name like that when I select data to load into the script. I connected to the Oracle database and didn't change anything after loading.

As it is a production database, cannot share my app.

Thanks for your help in advance.

topic Performing a join on data load from Oracle and Salesforce in QlikView

Performing a join on data load from Oracle and Salesforce

Re: Performing a join on data load from Oracle and Salesforce

Re: Performing a join on data load from Oracle and Salesforce