Problem indexing subentitienties from a multivalued field

[Jordi Martin <Jo...@indicator.es>]

Hi there

I have a problem trying to create subentities during the data import.

I have defined the following data-config

<entity name="efl" processor="FileListEntityProcessor" baseDir="/path/" fileName=".*.xml$" recursive="false" rootEntity="false" dataSource="null">
<entity name="subefl" dataSource="ds-3"  pk="id" processor="XPathEntityProcessor" forEach="/export/doc_debur"
                       transformer="DateFormatTransformer,RegexTransformer" url="${efl.fileAbsolutePath}" stream="true" onError="skip" >
                                ...
                                ...
                                ...
                                <field column="thk" xpath="/export/doc_debur/thematization_keys" />
                                <entity dataSource="ds-1" name="thematization_keys" query="select tmid as thematization_keys from thematization where tmid='${subefl.thk}' " />

                                ...
                                ...
                </entity>
<enity>

Thk is a multivalued string field
And thematization_keys is also defined as a multivalued string field

What I want is to make a query for each one of the values of thk and store all the results in the thematizations_keys field

Could anyone help me?

Thanks in advance
Jordi