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
BedrockMission!

Learn More

View all

Sign in to view all badges

Enrich: dynamically selected field

Avatar

Avatar
Validate 10
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
maurizio_coro
Level 2

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
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

80 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

80 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile
Deb007
Level 4

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
Validate 10
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
maurizio_coro
Level 2

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