cancel
Showing results for 
Search instead for 
Did you mean: 

Sub Query in Snap without Oracle

Harsha3
New Contributor III

Hi ,

I am trying to make a snap which replaces the simple sub-query . However I was not getting the proper count at the output . After knowing about the types of joins in snaplogic , I tried using them but the count is not in sync . Can I know what went wrong . Please find the sample files and sub-query used.

VV_ACT_CALL_DISCUSSION_EXTRACT.xlsx (814.1 KB) ------For the table “VV_ACT_CALL_Discussion_EXTRACT_ID”

VV_ACT_CALL_DETAIL_EXTRACT.xlsx (753.8 KB) ------For the table “VV_ACT_CALL_DETAIL_EXTRACT_ID”

Query used:

SELECT DISTINCT A.“Call_Detail_ID”,
A.“Call_ID”,
A.“Product_ID”,
A.“Country_Code”,
A.“Priority”,
A.“Type”,
A.“Is_Deleted”,
A.“Created_date”,
A.“Created_By_Id”,
A.“Last_Modified_Date”,
A.“Last_Modified_By_Id”
FROM VV_ACT_CALL_DETAIL_EXTRACT_ID A WHERE A.“Product_ID” NOT IN (SELECT B.“PRODUCT_ID” FROM VV_ACT_CALL_Discussion_EXTRACT_ID B
WHERE B.“CALL_ID” = A.“Call_ID”)-------Count in Oracle 2263 whereas in Sanp I get around 10K

Please let me know so that I can also attach my snap.

Thanks,
Harshavardhana

0 REPLIES 0