Hi Srikar, There are a number of options, for example:
- Create two property bridges, both with the same d2rq:property. One will be used if middle name is absent, one will be used if it is there. Give them appropriate d2rq:conditions to check for NULL/NOT NULL in the middle name column, and appropriate d2rq:patterns. - Instead of d2rq:pattern, use d2rq:sqlExpression, and write a SQL expression that produces the desired string regardless of whether middle name is NULL. Hope that helps, Richard On 1 Apr 2014, at 23:22, NADIPALLY, SRIKAR <nadip...@email.sc.edu> wrote: > Hi All, > > I am trying to map a Person table, it has first, middle and last names. > Sometimes the middle name might be null, I created something like the > following. > > map:Persons_name a d2rq:PropertyBridge; > d2rq:belongsToClassMap map:Persons; > d2rq:property foaf:name; > d2rq:pattern "@@Person.firstname@@ @@Person.middlename@@ > @@Person.lastname@@"; > . > > But this property does not show up when the middle name is missing, is there > any way I can still include the property even when the middle name is missing? > > Regards, > Srikar > > ------------------------------------------------------------------------------ > _______________________________________________ > d2rq-map-devel mailing list > d2rq-map-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ _______________________________________________ d2rq-map-devel mailing list d2rq-map-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
