Hi @gary07
Ok got it. Let me explain with a demo files and a flow to let you know how to design this process
Assume this master excel file :
Assume this is local file:
Now as you know 1st row of both are same, so we need to remove that row from the master file.
Let's see how we can design the flow 🙂
Step1: read the excel master and local file using excel actions like below:
Here MasterDt is master file data and LocalDt is local file data
2. Now use loop action to loop number of times (here master row count = local row count)
Loop settings should be like below:
Within the loop try these sub-steps:
a. set a variable strMaster with concatenating all column values of that row using comma as delimiter like below:
here expression %MasterDt[index][0]% represent current row first column
Simmilarly do the same for local file data as well:
b. use if condition to check if both variables are equal:
if condition is true use delete row action to delete the row like below:
exiting out of loop, use close excel to close the master file excel instance
Overall flow looks like this:
Hope it helps !
