(I apologise for the numerous edits on this post)
I am currently working on automating Microsoft Dynamics NAV 2013 Invoice Generation. I want the RPA to read data from excel, and copy paste it into NAV Sales Invoice Window, which I have already successfully read the data.
However, I don’t know how to copy and paste multiple running data or multiple sales invoice description into the same Excel Sales Invoice. What expression or activity should I use?
What expression should I put in my IF or WHILE statement to check if the current cell (Example A2) has the same value as the previous cell? (Example A1)
Do you need to get all the duplicated value from the column If yes Try with this expression
(From p in DT.Select() where( From q in DT.Select() where q("ColumnNameOrIndex").Equals(p("ColumnNameOrIndex")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()
Sorry but I’m not sure if I’ve understood your query since you titled it differently from the problem statement you have described so far.
Are you trying to say that you don’t know how to reference line items while they are inside of a For Each Row in DataTable or do you want to simply filter out Duplicate entries in Excel?
If you want to filter out duplicates, then based on which column do you want to remove the duplicates? I’m asking this since the rows themselves are actually unique, so if you want to remove duplicates you have to let us know on what basis you want the duplicates gone.
In the Excel, it states 3 rows for customer “2ROR-O-00000001”
with the difference being the “Description” (Example "ABC Sales Service, ABC Marketing Service and ABC Logistics Service)
Since they are the same customer, I want to write all 3 descriptions under 1 invoice.
However, I am not sure what expression to put in my “IF” activity to check if the customer in the current row is the same as the customer in the previous row.
I hope I have clarified your doubt and thank you for taking your time off to help out!
I’ve developed a workflow which doesn’t require you to rely on an If Activity.
Basically, we are grouping the items based on the first column and looping through the items in those groups →
In the xaml, you explained how to group them based on “Sell to customer no.”
In that group, all of the rows have this value “SHARED SERVICE - JAN 2022”.
What should I do or what expression should I use if I want UiPath to return the value “SHARED SERVICE - JAN 2022” (in a For Each loop)
However, I am not sure what expression to put in my “IF” activity to check if the customer in the current row is the same as the customer in the previous row.
