Hi, I am done with the workflow, Where I am comparing the data.
At Last I want to update the status in the New Excel Like
If data match in both the Excel then write the status Matched if not then Not Matched.
One more column for CustomerName.
I already have this variable with dynamic name
I created the Build Data Table,
with CustomerName and Status headers and store in a NewDT variable.
can you please tell me what I have to mention in the Add Data Row activity.
In the Status I can mention Match and Not Match in the Then & Else part of IF condition.
But how I mention this variable which contain my dynamic Customer Name.
Followed the approach.