Member since
05-01-2024
1
Post
1
Kudos Received
0
Solutions
05-01-2024
10:25 AM
1 Kudo
Hi I have a table where I have multiple conditions using operators or conditions. so, for each of the rows I need to get the variable name which has _ CONS_GRP = 'CCA' HL_GROUP_IN in ('1_HNO', '2_HO_W') and trim(PROD_SEG_MODL_DE) = 'VASO' CONS_SVC_GRP = 'CCA' and olb_cust ne 'A' output: for row1: Cons_grp for row2: HL_GROUP_IN PROD_SEG_MODL_DE for row3: CONS_SVC_GRP olb_cust I am okay if the output is in a row or column. appreciate any help.
... View more
Labels:
- Labels:
-
Apache Hive