@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)
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
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)
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.
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”
Brother! Please don’t change it again, I’m doing it!
@Ajay_Mishra sorry , It complicate logic.
Thank you for your support.
Done! 
Attaching the .xaml again!
JoinDataFilter.xaml (13.4 KB)
Input & Output File:
input1_Final.xlsx (12.2 KB)
Regards
Ajay Mishra,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
