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
