Enrich: dynamically selected field

Avatar

Avatar

maurizio_coro

Avatar

maurizio_coro

maurizio_coro

14-11-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Debabrata_T

Avatar

Debabrata_T

Debabrata_T

14-11-2018

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

Answers (1)

Answers (1)

Avatar

Avatar

maurizio_coro

Avatar

maurizio_coro

maurizio_coro

14-11-2018

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