Real time interview questions

[Gokul_Jayakumar (Gokul Jai)]

@Rakesh_Tiwari

there is invoice no text is available in excel file and excel file is having 1 lacs of records, how to find the cell index of that specific text.(There is no column is available as per interviewer).

1. Read the Excel data
2. Use “Lookup activity”, enter the string of value need. the cell value will get example C20, If starts from A1, use regex to spilt the number and get 20, index=20-2 can get the index value