Data loading activity & Enrichment activity

[rvnth]

Hi Team, 

Is there a method through which I can merge the data retrieved from the data loading activity with the enrichment activity, ensuring that all columns and their respective values are obtained from the corresponding schema (specifically, the feature schema in my case)?

I am getting 0 results , tried using the enrichment as well and still see 0. Please suggest

[LakshmiPravallika]

Hi @rvnth ,

Could you Please share us the configurations used in Enrichment activity as well.

Regards,

Pravallika.

[rvnth]

Hi @LakshmiPravallika ,

I've chosen data linked to the filtering dimension and designated the targeting dimension as the recipient table, with the filtering dimension set as the feature table.

Please suggest if I have to update my data  loading activity or any other changes

[AkshayAnand]

Hi @rvnth 

You can create a dummy field to create a join between the two transitions and merge the data.

For example: -

In the data loading activity, I loaded a file with Dummy field as "A".

And in the below transition after query, I used enrichment activity to create the same dummy field 

Now in the Union, I kept the primary set as the query transition and create a join on the dummy field.

And here is the result:

Hope this helps

Regards

Akshay

[rvnth · Accepted solution]

Hi @AkshayAnand 

What worked for me is  Enrichment activity after the data loading activity with reconciliation configuration under the advanced tab of enrichment

Thank you everyone