Hi all,
Am extracting data from excel to collection, for eg(only 4 columns). The first header is dynamically changing, others remains same .
For eg : My collection is having the headers like(sample 10 2018, customer, client, code). In this i have to extract the code (in D column), based on the value in "A column".
Issue : sample 10 2018, this 10 will change dynamically.
Expecting solution : If the "sample 10 2018" value is = code A, then i need relevant Column D (code).
NOTE : Please check the attachment for the detailed view (i have added as initial value, but when we are getting through collection from excel, it will be there in current value)
It would be very grateful, if someone could assist on this.
Am extracting data from excel to collection, for eg(only 4 columns). The first header is dynamically changing, others remains same .
For eg : My collection is having the headers like(sample 10 2018, customer, client, code). In this i have to extract the code (in D column), based on the value in "A column".
Issue : sample 10 2018, this 10 will change dynamically.
Expecting solution : If the "sample 10 2018" value is = code A, then i need relevant Column D (code).
NOTE : Please check the attachment for the detailed view (i have added as initial value, but when we are getting through collection from excel, it will be there in current value)
It would be very grateful, if someone could assist on this.