Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Performing a join on data load from Oracle and Salesforce

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:

partynumberDUNS_NUMBER_CD_U_N_S__c
--694346883
8064508694346883-
20282--

Correct output should be like below:

partynumberDUNS_NUMBER_CD_U_N_S__c
8064508694346883694346883
20282--


Message was edited by: lakshminarayana Palla

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

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

View solution in original post

Highlighted
Contributor III
Contributor III

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.