How to match the data in excel and paste it

Help Activities
, ,
1

I have an excel sheet data in a table i want to paste the data in yellow highlighted color in invoice column corresponding to Model column.
Please find the data attached.

image

Match.xlsx (8.3 KB)

2

@T_Y_Raju

just use join datatable and select left join with left being your main table

cheers

3

Hey,

If excel is new one, follow below approach

  1. Read the excel data.

2)Iterate Datatable

  1. Identify which data you want to past in the ‘Invoice’ column and take row count

  2. for Pasting the data in ‘Invoice’ column, use Write Cell activity and row count (for range)

  3. for Colour the data in ‘Invoice’ column, use Set Range Color activity and row count (for range)

If excel was already created and you are just updating the ‘Invoice’ column based on ‘Model’ column, you can follow below approach.

Use the Conditional format in the Excel this would be the bast way for colouring the cells.

4

what should the condition here plz let me know iam bit confused

image
image825×539 28.9 KB

5

@T_Y_Raju

why are you using same datatable

ideally it should be two tables?

and you need yo give the column names on which we need to match

cheers

6

there will only one excel sheet, where data will be available in the yellow highlighted
that data i have check with the table

7

can you help me with the logic involved
image

8

@T_Y_Raju

You need to read both of then as separate tables

As per screenshot we see two tables

Cheers

9

ok i have divided them into 2 tables iam confused in writing the logic and write back the data to invoice no
image

do we have to iterate the data table now

10

@T_Y_Raju

just give the common column names on each side

and then write the data back and check you would understand

cheers

11

initially there will be no data in the invoice column we have to take each row value of the highlighted value and match exactly with the model column where it matches and paste the data in invoice column to its corresponding. can u help me making flow for this actually iam new to UiPath

12

@T_Y_Raju

on the left side and riht side give 0 and select left in join

run and check

it would add extra column which we can rename to invoice column and delete empty column using filter datatable

cheers

13

its giving the total as 18 rows it has just joined the 2 tables when i run it

image
image1287×624 54.2 KB

14

hi i did same mentioned but giving the total no of rows.can you check on this.

15

@T_Y_Raju

Can you print the iniut datatable count as well

I believe it is same

Cheers

16

yes it has added the count of both datatables

17

@T_Y_Raju

Do you have any empty rows…can you check…ideally left join will add only the number of row as in ledt table alone

Cheers

18

it has empty rows it is counting them as well

19

it has given me the count …then may i know what should be the next step

20

@T_Y_Raju

then filter the empty rows and then join

cheers