I want to find data in file data compare with master file
If not found in master file write data in file output.
Please guide me about it.
I want to find data in file data compare with master file
If not found in master file write data in file output.
Please guide me about it.
@fairymemay Assuming the below points are always followed, I have created a workflow that provides the expected output, but however the format is not preserved as it is expected.
Check the below workflow :
Get Non Matching Rows.zip (24.8 KB)
Let us know if is not the expected solution and please revert back if it didn’t work, with Exception Screenshot or explanation if any.
@supermanPunch correct , Now I apply solution to if now found in data file write master in output file.
But I have problem about some row in data file have spacebar in last character then compare is not match.
Please guide me for solve it.
@fairymemay If you want to get the Non Matching rows from the Master File, then you would just need to shift the Datatable’s in the Second Assign Statement. From DT2 to DT1 and DT1 to DT2 as shown in the below Screenshots :
Let us know if you still do not get the expected output or if the requirements are different.
@fairymemay My Apologies I forgot to mention about the Trim part :
Can you include .Trim
on the row values as highlighted in the below images, It should generally remove the Extra Spaces and then compare :
Please revert back after you check on this.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.