Hi, I have created a campaign using the new subject in Information Map. subject 1: customers subject 2: policy+customer the join between the 2 subject is complex, but the key for the subject 2 is based on 3 fields. when trying to run a test sql query in information map I can see exactly what I was expecting to: PROC SQL Outobs=100; Create table WORK.%RESULT_TABLE_NAME% as SELECT DISTINCT table1.NK_IND_AGMT_ID AS DIR_2 LABEL='Nk Ind Agmt Id' FORMAT=$100., table0.IDENTIFICATION_DOC_NUMBER AS DIR_3 LABEL='Identification Doc Number' FORMAT=$50. FROM MACUST.DIM_SC_MI_ID_CUSTOMER_PANEL_CU table0 Inner join DWH.CV4_MVW table1 on ( (table0.IDENTIFICATION_DOC_NUMBER = table1.TZ) AND table1.LOOKUP_TZ = table1.TZ AND table1.LOOKUP_ID_DOC_TYPE = table1.ID_DOC_TYPE_CODE ) GROUP BY 1, 2; quit; but when exporting the data to a table I can see that fields are empty, so I trying to query in oracle sql the same query the information map gave me, and it givven me the fields and not returning null. which is exactly what I was expecting to. Why the CI is not doing the same connections and joins like the info map query? the export I have is only export the keys (level id) from both subjects. thanks
... View more