Comparison and display

Help Activities
, , ,
1

Hi Everyone,

I have 4 different Employee List with their Marks in 4 different sheets in single excel file

for example:-
one employee list with their marks
Name Week RPA SDLC AI ML
Ankit Week1 45 45 84 92
Ankit Week2 65 37 65 29
Ankit Week3 43 46 72 30
Ankit Week4 29 46 29 57

I have to

  1. Ask user to enter 2 Employee names and the Week Name.
  2. Compare their entered week marks
    & Display the name who has the highest marks in given week and his/her subject wise marks.

Please suggest me any solution with this with each step/activity to use

2

Hi @ankit.dutt

I have create a workflow that will be helpful to you to achieve your requirement.
Please go through the workflow, I have added annotation for better understanding of logics

CompareMarksOfTheEmployee.xaml (31.0 KB)

3

You can push this row data in to sql DB and by creating the query you can get the result