Hi Thank you for your response. I am running it for one account number select distinct msg_bet_id , atchd_doc_ref_id , idv_cd as Resident_Country_Code , idv_tin.tin as TIN , idv_tin.tin_issg_cntry_cd as TIN_Country_Code FROM tt17.crs_account_report a1 lateral view outer explode(hldr_idv_rsdnt_cntry_cds)exp1 as idv_cd lateral view outer explode(hldr_idv_tins)exp2 as idv_tin where accountnumber=123 ... View more