Text variable to Excel, compare and find missing items

Help
2

Hi
Hope these steps would help you resolve this
—use a excel application scope and pass the file path as input
And inside the scope use a read range activity and get the output with a variable of type datatable named dt
—now use a assign activity like this
finaldt = dt.Copy

Now use a clear datatable activity and mention the input as Finaldt
Where Finaldt is a variable of type datatable with default value as New System.Data.Datatable

—now next to this keep the get text activity and store them in a variable named str_input
And if it’s inside a loop then next to this get text activity use a ADD DATA ROW activity and mention the ArrayRow property as
{str_input.ToString} and Finaldt as datatable property input /// assuming that you have only column in ABC and DEF excel as well
Or we need to mention n number of elements in that array row property which is equal to the number of columns in mentioned datatable

Now once after this loop to find the matches and unmatched data between two datatable kindly have. A view in this thread

Cheers @Majo