How do I use an Excel list to determine results in a new DP.
I need to create a new Data Provider, but I want to limit the results to only the loans that are in my external DP (Excel ). I can’t use this “in List” feature in the query as there are over 50,000 reacords in my Excel list. Please help…I am new to BO
TMAXSON (BOB member since 2006-11-10)
I usually divide this kind of data in different columns with each column having 1000 rows.
Then I UNION queries to combine data for each column.
BUT with 50K rows that will be too much work and query performance will be another issue.
mkumar (BOB member since 2002-08-26)
Hi,
Have a look at this utility from the BOB’s Downloads section.
Marek Chladny 
(BOB member since 2003-11-27)
This utility is also limited by the number of values that can be passed to InList operator as there is a database limit to InList operator.
You will need to break the report in multiple queries to get this done.
mkumar (BOB member since 2002-08-26)
WOW! 50,000 entries??!? that’s a lot of of rows! are you sure you can’t break them down to different sheets? it’s a very big number. i don’t know if excel can accommodate that much.
chocolate101 (BOB member since 2008-02-28)