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

Update Data step - "key for matching records" not loading enumeration as dropdown

Avatar

Level 1

Hi,

I have an update Data step that need to update specific records. and I am providing the columns that need to be matched on. When I try to provide a column /field which is an enumeration, the values which are configured for this column/field in the schema are not coming as a drop down.

P.S. - The drop down is working fine in Fields to update

Has anyone seen this issue or knows a work around for this ?

We want to avoid any manual typing in order to avoid typo error, so it is important to be able to avoid any manual entry

/Regards

Kanwal

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Kanwal,

Update activity,

1248461_pastedImage_1.png

Highlighted area is used for reconciliation for dynamic values if you want to update values for a particular type of records you can use the other activity in which you can use drop down.

Use split or other activities to apply a filter which will give you this flexibility to use drop down like below screen shot.

1248460_pastedImage_0.png

you can also rely on distribution values in some scenarios like below:

1248462_pastedImage_2.png

Some time distribution values are beneficial in workflows to select correct options from the data base.

All you have to do is refine your workflow a bit.

Regards,

Amit

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi Kanwal,

Update activity,

1248461_pastedImage_1.png

Highlighted area is used for reconciliation for dynamic values if you want to update values for a particular type of records you can use the other activity in which you can use drop down.

Use split or other activities to apply a filter which will give you this flexibility to use drop down like below screen shot.

1248460_pastedImage_0.png

you can also rely on distribution values in some scenarios like below:

1248462_pastedImage_2.png

Some time distribution values are beneficial in workflows to select correct options from the data base.

All you have to do is refine your workflow a bit.

Regards,

Amit

Avatar

Level 1

Hi Amit,

The idea is to give this to marketeers in a template, so that when they use this to build their own campaigns, they don't have to manually type anything. 

The challenge is that any manual entry they will have to do can potentially end into a typo and the whole thing can go for a toss !

Thanks any ways.

/Regards

Kanwal