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?
