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.
Match.xlsx (8.3 KB)
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.
Match.xlsx (8.3 KB)
Hey,
If excel is new one, follow below approach
2)Iterate Datatable
Identify which data you want to past in the ‘Invoice’ column and take row count
for Pasting the data in ‘Invoice’ column, use Write Cell activity and row count (for range)
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.
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
there will only one excel sheet, where data will be available in the yellow highlighted
that data i have check with the table
can you help me with the logic involved
You need to read both of then as separate tables
As per screenshot we see two tables
Cheers
ok i have divided them into 2 tables iam confused in writing the logic and write back the data to invoice no
do we have to iterate the data table now
just give the common column names on each side
and then write the data back and check you would understand
cheers
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
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
hi i did same mentioned but giving the total no of rows.can you check on this.
yes it has added the count of both datatables
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
it has empty rows it is counting them as well
it has given me the count …then may i know what should be the next step