I have a query…
“I have raw report” and “multiple input files inside one folder”.
query :- i would like to match the values of each record from raw file one by one with “Input Files”. if it matches then output the value from input.
Condition :- the input files will have specific numbers for each records which is mentioned in raw files. so the iteration should be only to those input file.
for reference i have attached the excel files.
please let me know how can i achieve this.
Hi @Manish540, thank you but i think there is some confusion.
you have used for each file and then used the matching logic. but what i need it…
BOt should first pick the Req number from Raw report and then check the corresponding files…
E.g. BOT open the Raw Report— pick the first row with Req Number “100” – then BOT went to Dataset Folder – Search for files which contains “100” in file name (Data_100_1 and Data_100_2) only this two files – first Match with “Class Unique Identifyer” if it found in Data_100_1 then Match the other fields… if not then move to next file which is Data_100_2 and Match the column "“Class Unique Identifyer” if matches then match the other fields.
i want to know what logic i should write so that bot can only pick those two files from data set while check for 1st row of Raw report. Updated Excel.zip (36.4 KB)
your bot says for each item in file list but i need for each Row in row report search for files in data set.
please see below example. Updated Excel.zip (36.4 KB)
E.g. BOT open the Raw Report— pick the first row with Req Number “100” – then BOT went to Dataset Folder – Search for files which contains “100” in file name (Data_100_1 and Data_100_2) only this two files – first Match with “Class Unique Identifyer” if it found in Data_100_1 then Match the other fields… if not then move to next file which is Data_100_2 and Match the column "“Class Unique Identifyer” if matches then match the other fields.
