Multi-Assign fields for Field of type date

bhushanc

• October 25, 2013 00:00

• Answered

Follow

Hi,

I am reading data from d/b table and My table has multiple rows for one person which contains date fields too. I am using denormalizer to merge multiple records to single record for person where all fields except personId field are separated by pipe(|) operator. But denormalizer is showing an error for date field as unparsable date say 2011-01-01|2012-01-01|2013-01-01.

How we can handle date fields in this scenario so that we will have date fields as pipe(|) separated.

FYI : I am using "Bulk Add/Replace Records" component where I am using Multi-Assign delimeter as pipe(|). so that it gets indexed in endeca.

• 

  admin

  • October 25, 2013 13:54

  0

  Comment actions Permalink

  Hi,
  
  What data type is field where you store dates? If it is DateTime type, then I am afraid it cannot store pipe delimited data. You can use String type instead.
• 

  bhushanc

  • October 28, 2013 06:01

  0

  Comment actions Permalink

  Yes its of type Date. I am using Oracle Endeca Information Discovery(OEID) where I am indexing data into Endeca. We have multiple fields of type date and int which we need as multi-assigned fields in endeca.
  
  Is there any workaround for this?
  
  Thanks
• 

  admin

  • October 29, 2013 07:48

  0

  Comment actions Permalink

  Hi,
  
  I am afraid that there is no workaround. The Date field cannot handle multiple values. Only possibility is to change it to String type and store serialized dates separated by pipe (or other character).
  
  Also, from CloverETL 3.3.0 on there is support for http://doc.cloveretl.com/documentation/ ... ields.html but I am not sure what version bundles your OEID. Please contact Endeca support, they will know more.

Please sign in to leave a comment.