Multi-Assign fields for Field of type date

CloverDX Platform
1

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.

2

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.

3

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

4

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.