How to put the particular condition in if

[anjani_priya]

the condition is
the column a = column b then column c is replaced with the value
if it doesnot then column d is placed in new sheet

[sasi_poosarla (sasi p)]

@anjani_priya
can you please share expected input and output
so i can work on it!!

Cheers!!

[rlgandu (Rajyalakshmi Gandu)]

@anjani_priya

Please Share the Input and output Screenshots

[Vinit_Kawle]

Hi @anjani_priya ,

Thanks for reaching out.

you can follow the below logic

But for a more detailed explanation please provide more details.

Happy Automation,
@Vinit_Kawle

[anjani_priya]

sheet2.xlsx (34.0 KB)
sheet1.xlsx (38.6 KB)
there are two sheets
sheet1 sum(books needed)=sheet2 sum(actual quantity)
if it equals then sheet1 section column values should be A
if it doesnot equals then sheet2 age column should be copy paste in new column and remove duplicates

[anjani_priya]

sheet2.xlsx (34.0 KB)
sheet1.xlsx (38.6 KB)
there are two sheets
sheet1 sum(books needed)=sheet2 sum(actual quantity)
if it equals then sheet1 section column values should be A
if it doesnot equals then sheet2 age column should be copy paste in new column and remove duplicates.

[anjani_priya]

sheet2.xlsx (34.0 KB)
sheet1.xlsx (38.6 KB)
there are two sheets
sheet1 sum(books needed)=sheet2 sum(actual quantity)
if it equals then sheet1 section column values should be A
if it doesnot equals then sheet2 age column should be copy paste in new column and remove duplicates…

[pravallikapaluri]

@anjani_priya
Can you elaborate your question

[Vinit_Kawle]

can you please specify which columns need to compare?

[anjani_priya]

sheet2.xlsx (34.0 KB)
sheet1.xlsx (38.6 KB)
there are two sheets
sheet1 sum(books needed)=sheet2 sum(actual quantity)
if it equals then sheet1 section column values should be A
if it doesnot equals then sheet2 age column should be copy paste in new column and remove duplicates
the sum’s of 2 columns in 2 different excel files should be compared and if it equals then above condition if not then above second condition

[anjani_priya]

books needed col sum and actual quantity sum should be equal if it is then a condition if it doesnot than a condition

[anjani_priya]

the sum’s of 2 columns in 2 different excel files should be compared and if it equals then above condition if not then above second condition

[mkankatala (Mahesh Kankatala)]

Okay @anjani_priya

→ Use the read range workbook activity to read the excel and store in a datatable datatype variable, let’s call it as dt_Input.
→ After read range use the assign activity to write the below expression

- Assign -> Currentrow("name") = "xyz"

→ out of for each insert the Write range workbook activity to write the dt_Input to the same excel sheet. In the properties of Write range workbook activity check the add headers option.

Check the below workflow for better understanding,

Input -

Output -

Hope this helps!!

[mkankatala (Mahesh Kankatala)]

Thank you @anjani_priya

Happy Automation!!