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

Avatar

Avatar
Validate 1
Level 1
kanwalAdobe
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
kanwalAdobe
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
kanwalAdobe
Level 1

12-07-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
Amit_Kumar
MVP

12-07-2017

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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
kanwalAdobe
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
kanwalAdobe
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
kanwalAdobe
Level 1

13-07-2017

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