Just a suggestion ..
You can try using dynamic fields by appending the company name (or ID)
as prefix ... e.g.
For data -
Employee ID Employer FromDate ToDate
21345
IBM 01/01/04 01/01/06
MS 01/01/07 01/01/08
BT 01/01/09 Present
Index data as :-
Employee ID - 21345
Employer Name - IBM MS BT (Multivalued fields)
IBM_FROM_DATE - 01/01/04 (Dynamic field)
IBM_TO_DATE - 01/01/06 (Dynamic field)
You should be able to match the results and get the from and to date
for the companies and handle it on UI side.
Regards,
Jayendra
On Wed, Mar 23, 2011 at 8:24 AM, Sandra wrote:
> Hi everyone,
>
> I know that Solr cannot match 1 value in a multi-valued field with
> the corresponding value in another multi-valued field. However my data set
> appears to be in that form at the moment.
> With that in mind does anyone know of any good articles or
> discussions that have addressed this issue, specifically the alternatives
> that can be easily done/considered etc
>
> The data is of the following format:
>
> I have an unique Employee ID field, Employer (multi-value), FromDate
> (multi-value) amd ToDate (multi-value). For a given employee ID I am trying
> to return the relevent data. For example for a ID of "21345" and emplyer
> "IMB" return the work dates from and to. Or for same id and 2 work dates
> return the company of companies that the id was associated with etc
>
>
> Employee ID Employer FromDate ToDate
> 21345 IBM 01/01/04 01/01/06
> MS 01/01/07 01/01/08
> BT 01/01/09 Present
>
> Any suggestions/comments/ideas/articles much appreciated...
>
> Thanks,
> S.
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Solr-multivalue-fields-please-help-tp2720067p2720067.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
