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

Is it possible to add array of values to single column in profile schema in Adobe campaign standard

divyas70997717
Level 3
Level 3

Hi,

 

I have a scenario where a single profile will have multiple program values which will be comma separated values in profile import file "program" column.

ex: column name- "programs", column value- "test1,test2,test3".

It is also mentioned that they have fixed 15 values like (test1, test2 ... test15). In which profile can have anything from this list. what is the best approach to import this. Also the imported profile values can be changed in adobe campaign in future. So i should provide feasibility to add one more program value for program column for a profile.

 

Should i create a new custom resource for Programs? Kindly suggest.

 

Thanks in advance,

Divya

 

1 Accepted Solution
ramon_bisswanger
Correct answer by
Employee
Employee

Yes, best would be to create:

  • custom resource Program
  • another custom resource ProfileProgramReference which contains the relation between the 2 resources

View solution in original post

4 Replies
ramon_bisswanger
Correct answer by
Employee
Employee

Yes, best would be to create:

  • custom resource Program
  • another custom resource ProfileProgramReference which contains the relation between the 2 resources

View solution in original post

divyas70997717
Level 3
Level 3

thank for your response.

So in custom resource, the test1 & test2 will be the separate columns? or there will be one column named "programs" and values will be "test1" and "test2?

How that custom resource table will look like?

ex1 :  Email                   test1       test2        test3

         person1@mail.com.      yes        yes            no

         person2@mail.com.      no.        yes         yes

 

(Or)

ex2 :  Email                                 programs

        person1@mail.com              test1,test2

         person2@mail.com.              test2,test3

 

Thanks in advance

Divya

ramon_bisswanger
Employee
Employee

if you do add them as test1,test2,... it would rather get complex to define amd also not too easy to add new values later on.

 

So I would rather approach it as:

 * No custom attributes on the profile

* instead a new custom resource called cusPrrogram or so - 1 object exists per unique record (e.g. test1)

* New custom resource to link profile with the cusProgram resource (i.e. per "yes" assigned to a profile, there would be 1 instance of the link resource)