How to include or exclude accounts on the bases of range

[vijayyd]

I have a list of 18,000 accounts and I want to build a flexibility to include or exclude account numbers from the range.

Input file will consist of account number list 

Account Number example

1143400

1133402

1243404

1343401

1443423

1643400

2143409

Account number range example (also need flexibility to change range criteria):- 

Account Range Description	Account number Range
	From	To
Debtors	1143400	1143500
Loan Repayments	1303400	1303700
Fixed asset related	1310300	1320500
Prepaid expenses	1340500	1340700
Inventory	1340704	1340704
Deferred Prepaid expenses	1340800	1341100
Deferred P&L adjustments	1341100	1341200
Prepaid	1345400	1345700
Goodwill	1346700	1347000
Investment	1350000	1370100
Minority interests	2167000	2167600
Equity	3000000	4000000

[PangHC · Accepted solution]

generally, here the method.
1. append all to the account. use filter to remove others. 
2. add back the not match account. (if you still required the unmatch account)

[Qiu]

@vijayyd 

We can use Generate Rows tool to expand the Account number ranges then do a join with your first input files.

[Peachyco · Accepted solution]

We can also use Dynamic Replace to test each input against each range in the master list.

The Formula Tool is there to create the fields/expressions that Dynamic Replace will need:

 

And this is the configuration of the Dynamic Replace Tool: