Filter Data more

@Ajay_Mishra From forum Join data and filter - #15 by Ajay_Mishra

If I want check more detail as below.

If In file input and file report match same data column SR (more row)
I want to check last row from this SR and same condition follow previous forum.

Please guide me for solve it.
Thank you.

example data as attached.

input1.xlsx (11.0 KB)
report.xlsx (9.0 KB)

1 Like

@Stef_99

Got the Solution!

Hey @Stef_99

Attaching .xaml for your reference!
JoinDataFilter.xaml (13.1 KB)

Regards,
Ajay Mishra

@Ajay_Mishra I have wrong output.

in file input if match data column SR and act with file report and column close blank or working

Don’t filter it in datatable

image

Please guide me for sove it.

input1.xlsx (10.9 KB)
report.xlsx (9.0 KB)

Thank you

@Stef_99 So you don’t need the rows whose SR & act should match with respective columns in Report but close column should be blank?

@Ajay_Mishra yes , close colume balnk or text working

And some time column Check_duplicate have Y all not have N —> it error

Can you have solution for check for solve error?

Thank you

So, why you have not added below mentioned row in expected output sheet? it has same SR, act & No blank value or working at close column?

4 4 N

Regards,
Ajay Mishra

@Ajay_Mishra case 4 4 N —> I example wrong it not found this case because column close not bland and not text working.

@Stef_99 I didn’t get it, please elaborate more!

@Ajay_Mishra I have new file attached.

expect output
1 1 N —> because not found sr in file report
3 3 N —> because not found sr in file report
5 6 N —> because last row sr=5 column close = blank or “working”
4 2 N —> because sr 4 in file report column close <> blank or “working”
6 7 N —> because sr and act in file report = blank or “working”

input1 (1).xlsx (11.5 KB)
report (1).xlsx (9.4 KB)

@Stef_99

How 1 1 N row will be in expected output?
As you can see in the screenshot of report sheet it’s close column has working!

Regards,
Ajay Mishra

@Ajay_Mishra oh, sorry I mistake.

1 1 N not copy to datatable → beacuse 1 1 in file report have working.

@Stef_99

I’m getting the expected Output then, I didn’t changed anything in the code!

Attaching the .xaml again!
JoinDataFilter.xaml (13.4 KB)

Input & Output File:
input1_Final.xlsx (12.4 KB)

Regards
Ajay Mishra,

@Ajay_Mishra sorry

6 7 N —> don’t copy to datatable because same sr and same act in file report = blank or “working”

@Stef_99 :neutral_face: :sweat_smile:

Brother! Please don’t change it again, I’m doing it!

1 Like

@Ajay_Mishra sorry , It complicate logic.

Thank you for your support.

@Stef_99

Done! :100:

Attaching the .xaml again!
JoinDataFilter.xaml (13.4 KB)

Input & Output File:
input1_Final.xlsx (12.2 KB)

Regards
Ajay Mishra,

1 Like

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