About rajchi

rajchi · ‎07-15-2016

The maximum limit for "external lookup" is also 1000 for maximum matches. Please let me know if someone has done this before or if someone can confirm it is not possible at all.

rajchi · ‎07-15-2016

Thanks for your reply, so there is no way I can match more than 1000 using lookup?

rajchi · ‎07-15-2016

Thanks for your reply, but it is not working. You can't increase the value of maximum matches above 1000 from UI lookup definition. It gives error from UI if you will try to increase it above 1000, I did try from limits.conf as well but it is not working.

rajchi · ‎07-15-2016

Lookup table max match can be 1 to 1000, I want to increase it to 2000. Is it possible? When I increase the max_matches in limits.conf then it is not taking, is there any other way to achieve this?

rajchi · ‎03-07-2016

Thanks a ton, you saved my day 🙂

rajchi · ‎03-07-2016

Thanks for your reply @somesoni2, really appreciate it. Somehow option 2 is not working, I can try option 1 as well but my lookup table have other columns too like "start_time" and "end_time". If indexed field(i.e. file_name) is matching to lookup table field(i.e. file_name) then I have to check whether _time(indexed file field) falls between "start_time" and "end_time"(lookup table field) or not.

rajchi · ‎03-07-2016

I want to compare an indexed file with lookup table, where lookup table field is substring of indexed file field Sample Indexed file: _time file_name 03/04/16 7:00 ABC.DFG.123 03/04/16 7:00 DEF.DF.A123 03/04/16 7:00 QWE.DFG.ABC.peter 03/04/16 7:00 DBC.D.030416 03/04/16 7:00 QASDFG.123 03/04/16 7:00 ASDDFG.ABC.ZXC.MKL123 03/04/16 7:00 DEF.DF.A123 03/04/16 7:00 QWE.DFG.ABC.peter 03/04/16 7:00 DBC.D.030416 03/04/16 7:00 QASDFG.123 03/04/16 7:00 QASDFG.123 03/04/16 7:00 ASDDFG.ABC.ZXC.MKL123 03/04/16 7:00 DEF.DF.A123 03/04/16 7:00 QWE.DFG.ABC.peter 03/04/16 7:00 DBC.D.030416 Sample Lookup table: file_name ABC.DFG DEF.DF. QWE.DFG.ABC. DBC.D QASDFG ASDDFG.ABC.ZXC.MKL

Posts	7
Solutions	0
Karma Given	1
Karma Received	4
Member Since	‎03-25-2015

Online Status	Offline
Date Last Visited	3 weeks ago

can we increase lookup table maximum matches to 20...

Compare indexed file with lookup table where looku...

Re: can we increase lookup table maximum matches t...

Re: can we increase lookup table maximum matches t...

Re: can we increase lookup table maximum matches t...

can we increase lookup table maximum matches to 20...

Re: Compare indexed file with lookup table where l...

Re: Compare indexed file with lookup table where l...

Compare indexed file with lookup table where looku...

Join the Conversation