Robust transformer - multiple target records from single source row

[zdravkonedev]

Hello,

I have a JDBC data source and I'd like to use Robust transforms to produce multiple target records from a single row in the staging table.

In the import set table a field may contain a comma-separated values and if that is the case I'd like multiple records to be inserted in one of the target tables and at the same time only one record to be created in another target table. Scenario is to create a Business Application and several Application Services along with their relationships.

I have tried creating a temp ETL entity where I have 2 ETL Fields - one for the input string (mapped to the Import set field containing the comma-separated values) and another one defined as an array with a path "environments[*]" which I try to feed via a scripted RTE Entity Operation which returns an array build by the comma-separated string value. The path of the target entity is also defined with '[*]' at the end.

I get an error which states "Transfomation failed: No matching wildcard rules for symbol: {entity}.{entity_field_name}[*], source path: null"

Has anyone come across a similar situation?

Thank you.

[Eric Therrien]

Hi @zdravkonedev , I have a similar use casse (a field with a comma separated list of values that I need to create invidual CIs from and relate to the "main" CI) and haven't been able to figure it out. Some months ago, I started playing with this and had to stop. Today I'm back on this and have lost a bit of knowledge I had gathered when first working on it. I'm trying to find the example I had found that explained how to do the array, but can't event find this back...

So hopefully you got further down on this and might be able to share your findings...