Dear Team,

I have a spread sheet which contained 8 columns and every day data ( rows ) will append to the spread sheet. I need a solution to read only 4 columns ( 1 column is Account number as key field ) into Automation, filter the data by passing required account number and read the rest of 3 columns data ( Name , DOB and Address ) for that account number.

Please suggest if any one had already a solution for this.

Thanks,