Expand my Community achievements bar.

SOLVED

Enrich: dynamically selected field

Avatar

Level 3

Hello, I'm wondering if there's a way to have a dynamically set query:

I've 3 fields in the country table: offset1, offset2, offset3 and I'd like to assign one of this to a variabile inside a WF, something like that:

var.offset = recipient/country/@offset2

(meaning it will refers to the value inside the offset2 field)

Then, in a Enrichment activity, I need to add data from the corresponding field, so like if I wrote directly:

[recipient/country/@offset2] but using the variabile, because the reference depends on other custom behaviors.

Is there a way inside the Select additional columns window?

1620732_pastedImage_0.png

I've tried to concatenate string and variable, but it didn't work.

Any idea?

thanks

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi maurizioc92956636​,

Once you have value in your variable using javascript, you can use the enrichment like following.

In Javascript

vars.sample="abc";

In Enrichment

1621546_pastedImage_0.png

Regards,

Deb

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi maurizioc92956636​,

Once you have value in your variable using javascript, you can use the enrichment like following.

In Javascript

vars.sample="abc";

In Enrichment

1621546_pastedImage_0.png

Regards,

Deb

Avatar

Level 3

so, in my case, something like:

vars.fieldname = offset2;

and as enrich expression:

recipient/country/ + $(vars/@fieldname)

I'll give it a try, thanks a lot.

Maurizio