0 Replies Latest reply: Aug 14, 2013 1:46 AM by Nevin Kumar RSS

    Retrieve data from different rows using QVD based on condition

      I am trying to pull data from QVD file for the below conditions and populate the data in List box.

       

      If IDENTIFIER = "BSA DRY RUN" populate rows for BSA DRY RUN, REGION  and CONSENT

      If IDENTIFIER = "NBN DRY RUN" populate rows for NBN DRY RUN, ADDRESS and CONSENT

       

      QVD file has the below data format, column names (ie, IDENTIFIER, ItemA, ItemB)

       

      IDENTIFIER         ItemA                                      ItemB

      BSA DRY RUN     BSA DRY RUN REPORT:     THIS REPORT HELPS BUSINESS USERS

      NBN DRY RUN     NBN DRY RUN REPORT:     THIS REPORT HELPS END USERS

      REGION                      REGION.REGIONID             REGION ID OF THE CUSTOMER

      REGION                      REGION.REGION_NAME      NAME OF THE REGION

      ADDRESS                      ADDRESS.PAYLOAD_ID          CLIENT UNIQUE ID

      ADDRESS                  ADDRESS.BATCH_ID                BATCH ID

      CONSENT                  CONSENT.CIDN                 CUSTOMER ID

      CONSENT                      CONSENT.CIDN_DESCRIPTION      CIDN DESCRPTION

       

       

       

      COULD SOMEONE PLEASE LET ME KNOW HOW TO DO THIS?