Add condition for check condition?

[fairymemay (noona)]

From previous post

Compare range and write data?

you can refer to my xaml. Main1.xaml (25.3 KB) Input and config file: InputFile.xlsx (9.7 KB) ConfigFile.xlsx (18.9 KB) Input [image] result [image]

@jack.chan I have a question

If I want add more condition for filter.

1. Check Column Start_APPDate and End_APPDate → But if some row , some column = blank not check.
   Example file config as below.

first row , Start_AppDate = 25650301 but End_AppDate = Blank
I want compare range and column App Date (Start_APPDate >= 25650301 , not filter End_AppDate

But if second row , Start_AppDate = 25650301 but End_AppDate = 25650331
I want compare range and column App Date (Start_APPDate >= 25650301 , End_APPDate <= 25650331)

2. Check Column Start_PaidDate and End_PaidDate (follow condition (1))
3. Check Column Start_IssueDate and End_IssueDate (follow condition (1)) and include IssueDate = 0

Please guide me for solve it.

[jack.chan]

so condition is:

1. specific rate <= FYP <= specific rate 2
2. start app date <= appDate <= end app date
3. start issue date <= issueDate <= end issuedate
4. start paid date <= paidDate <= end paid date

Correct?

[fairymemay (noona)]

@jack.chan specific rate <= FYP <= specific rate 2 —> same condition as previous flow.

1. start app date <= appDate <= end app date // yes 
2. start issue date <= issueDate <= end issuedate  //  Start issue date <= issueDate <= end issuedate or issueDate  = 0 
3. start paid date <= paidDate <= end paid date   // yes 

[jack.chan]

can you try this
Main12.xaml (73.1 KB)

[fairymemay (noona)]

@jack.chan in file input that row highlight yellow as below.

But output don’t stamp in column Item and Amount.

It should stamp Bag17.

Please guide me for solve it.

[jack.chan]

here you go
Main12.xaml (81.1 KB)