How to compare data in a column if it matches with ADMN word should write same word in another column.Can anyone help me please it's Urgent

Help Studio
1

image
image719×642 37.4 KB

This is the excel image and in this Entitle column i should check for ADMN data if it present i should write same word on Access Type column. Can anyone help me plz.

image
image740×427 5.65 KB

This is final excel image in which i should modify the data in this format.

2

@sandhyareddy

3

Hi @sandhyareddy
Inside a Loop
use an if activity

if
currentRow(“Entitlement (Group/Role)”).toString=“ADMN”
then
currentRow(“Access Type - Admin or Normal”)=“ADMN”
else
currentRow(“Access Type - Admin or Normal”)=“Normal”

Thanks

4

Hi @sandhyareddy

1)Use the read range to read the entire Excel and store it into an Datatable say dt_data.
2)Now use For each row in Datatable.- Input: dt_data
3)Under the use an If condition saying
CurrentRow(“Entitlement”).ToString.Equals(“ADMN”)
4)Use an Assign activity:
CurrentRow(“Access Type”).ToString= “ADMN”
5)Use Write Range Workbook:

  • Input: DataTable: dt
    • Specify the range to write back to the Excel file
5

@sandhyareddy : Please find attach code for your reference, Please let me know in case any issue
ExcelUpdate.zip (9.9 KB)

6

image
image1344×295 14.2 KB

this is the error i am getting

7

hi @sandhyareddy ,

You have to use the full Column Name in your case it is: “Entitlement (Group/Role)”

Thanks

8

image
image997×380 14 KB

9

Hi @sandhyareddy

Try copying the column name from the excel and pasting the same in the syntax. The input excel may have some spaces when created. Check that and give. If possible share the screenshot and dummy excel so I can find exact solution for you

Hope it helps!!

Regards,

10

Can you share your workflow? can check it and respond back

11

Book.xlsx (18.1 KB)
Main.xaml (11.3 KB)

12

In the Book.xlsx file, initially in Access Type - Admin or Normal column no data is present. So, i want to compare the data withEntitlement (Group/Role) column if data matches with ADMN. then i should give same word in Access column or else i should mention Normal

13

@sandhyareddy : this column name should match with your data sheet, i used file with column name entitlement, you need to change it as per your file

14

yes changed, but still getting wrong data. like whatever present in Entitlement column getting same in Access column.

15

Hi @sandhyareddy

I have uploaded the zip file for reference. Please check and say whether if it’s working fine.

Test.zip (1.1 MB)

Hope it works!! Happy Automation.

Regards,

16

@sandhyareddy : yes because in else condition i have mentioned that, you need to make small change in else condition where you will update it to NRML

17

Hi @sandhyareddy

You can use this workflow,

Book.xlsx (18.0 KB)
SandhyaWorkflow.xaml (8.5 KB)

Your mistake was that you weren’t passing the same column name as mentioned in excel at both the places.

In the IF condition: CurrentRow(“Entitlement (Group/Role)”).ToString.Equals(“ADMN”)
In the Assign inside IF: CurrentRow(“Access Type - Admin or Normal”)

Happy Automation

18

Hi @sandhyareddy

Please check the zip file for reference.

Test.zip (1.0 MB)

Regards,

19

Thankyou all for your lovely help. It helped me alottt Once again Thankyou! Soooo muchhhhh. :slightly_smiling_face:

21

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