I have to apply v-look up referring 2 excel sheets and copy 2-3 columns of one excel sheet into the new sheet based on v-look up results. Example: Apply v-look up of column 1 of excel sheet 1 with column 3 of excel sheet 2. Based on the match, add column 8, 9 and 10 of excel sheet 2 into a new excel sheet 3. Please provide a sample flow to achieve it.
As primary steps, I tried doing it with activity “Merge data table” but 2nd data table rows are appended after completion of 1st data table rows which was unexpected behavior. I also tried “for each row” loop inside another “for each row” loop which turned horribly wrong.