[Fast Data] [SVC Low Code] Reference to the same projection

[flower-of-the-bridges]

Hi

I need to link a projection, namely PROJ_1, to itself under the following condition:

{
  'FIELD_1': '__string__[value]'
  'FIELD_2': 'FIELD_3' 
}

This condition, that we can assume is named CONDITION_1, is then used in the aggregation in the following way:

config: {
    SV_CONFIG: {
      dependencies: {
        PROJ_1: {
          type: 'projection',
          on: '_identifier',
        },
        PROJ_1_DUPLICATE: {
          type: 'projection',
          aliasOf: 'PROJ_1',
          on: 'CONDITION_1',
        }
    },
    mapping: {
    // ...
    mapping1: 'PROJ_1_DUPLICATE.FIELD'
    }
}

When the condition is not met, I expect to have mapping1: null.
However, the field mapping1 is not returned by the aggregator.

I'm approaching the problem correctly or there is another solution that fits better to this case?

[STartarotti]

Hi,

at the moment this particular case is not among the ones supported by the aggregation schema.
However you could always define a custom function with the __fromFile__[fileName] feature of the mapping.