Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Enrich: dynamically selected field

maurizio_coro
Level 3
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
Deb007
Correct answer by
Level 6
Level 6

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
Deb007
Correct answer by
Level 6
Level 6

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

maurizio_coro
Level 3
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