hi Austin, Thank you very much for your answer: for 1 - we are going to PostgreSQL of the VI and union the result of the query to the PREP table so PK will be there for disposition: (As a big picture): create table FINAL_PREP_TABLE as select col_PK, col1, col2,col3 from PRER_TABLE_BEFORE_FINAL union all select al."actionable_entity_id",null,null,null from avi_Alert.tdc_alert_v al-- from PG where al."actionable_entity_type_nm" = 'AAA' about 2 and 3: we've opened Case CS0054656 SAS Vi 10.8: send queries to external DB - if you can take a look there for more details it will be great! We will publish the result for all here after that. Thanks a lot, Alex.
... View more