Hello community i have one business scenario where i have one input excel file in that having multiple ATMID for each atm id i have separate text file and i want to check transaction details like TXN Number, ATM ID,TXN Date, Card number and TXN Amount in each text files .
for example if ATM ID is SPCNR015 i want check in text file like these i want to check for each ATMID .
for every ATM ID there is separate
use ReadTextFile Activity to read the txt file.(Var called txt)
Then Read Excel file (Var called dt_Excel)
Use For each row in datatable activity
i)Get ATMID=Currentrow(“ATM ID”).tostring
Try this…Let me know if you have any doubts
Hello @Akash_Javalekar ,
You can use each data table and read the text file by using the name of file.
By using the regex condition you can pass the ATMID and can get the Green marked text from the file.
how bot know which text file is for which atmid in the excel once atm id is matched i want to compare other details like txn number,card number & txn date for every row in excel
can you explain step by step how i do this?
If all are in the same folder, read the text file and use it based on Currentrow like Yourlocation+"\"+Currentrow("ATMID")+".txt"
For each loop based on ATMID, the bot will read the corresponding Text file