Filtering the Column value

Help Activities
, , , , ,
1

I have excel and excel keeps two column one is time in state and second is threshold failed. I want if the threshold failed value is greater than the time in state, then make an another output filter excel and put the value in it.
Example-Input and output is present in attached file
Input_1.xlsx (10.5 KB)
Output.xlsx (9.3 KB)

2

Hi @Himanshu_Pratap_Rana

Requirement is a bit unclear
How do we go from this input to that output.
And from where Break, ACW, Logged out comes into the picture.

3

Sorry input will be
Input_11.xlsx (10.4 KB)

4

Hi @Himanshu_Pratap_Rana
You would have to use multiple assign statements in the loop something like this:

sumBreak.Add(TimeSpan.Parse(CurrentRow(“Time in State”).ToString))

image
image780×619 17.1 KB

5

Can you share the xaml with correct output?

6

hi @Himanshu_Pratap_Rana

You can add more if conditions as needed inside the loop and try to create for all of them.
Below are the files:
Grouping.xaml (11.2 KB)
GroupTIme.xlsx (7.2 KB)
Input_11.xlsx (10.4 KB)

Thanks,
Aditya

7

@adiijaiin i want in output that if threshold value is greater then time state then add in output(grouptime.xlsx).your output value is less then to the time in state.