Input duplicate data into row

Help Activities
, , ,
1

Hi,

I have this table as shown below. I have already inserted it as a Datatable but now I want all the rows who have the same “Batch” number to have the same “Quantity”. I will then need to export it as an excel.

Can you tell me which “Activities” or how I can do it please?
Thanks!

uipath_jpeg_1
uipath_jpeg_11132×612 90.8 KB

2

@Yudhisteer_Chintaram1

Follow the below steps…
OriginalDT in the below screenshot is your original table in the first image

image
image706×781 23.8 KB

Also, have attached the workflow TwoForEach.xaml (11.9 KB)

4

@Yudhisteer_Chintaram1

Check below for your reference

Hope this helps you

Thanks

5

Check this below workflow reduced with linq queries, @Yudhisteer_Chintaram1
Uipath_InputDuplicateData.xaml (12.8 KB) and also check the output file attached Duplicate_Output.xlsx (7.4 KB)
Hope this may help you :slight_smile:

6

Hi Pravin

Thanks for the help!I t works!
I am not that proficient in UIPath. Could you please explain your steps?

  1. What does varUniqueDT does?
  2. And your For loop?

Thanks!

8

@Yudhisteer_Chintaram1

  1. varUniqueDT is a variable of data table type which is just holding all the unique batches with non-empty quantity.
  2. Then I’m looping through each unique value data table and updating the original data table where the batch number is matching.
1 Like
9

Thanks!

10

Thanks!!

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.