Is it possible to add array of values to single colum...

[divyas70997717]

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

[ramon_bisswanger · Accepted solution]

Yes, best would be to create:

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

[divyas70997717]

thank for your response.

[divyas70997717]

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]

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)