• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 225 views
  • Users 0 members are here
Options
Related

Merge several lines CSV write connector

c polignano
7 days ago

If I have an account who has two or more group for a specific target, for example

Account1,Group1

Account1, Group2

I need to write a CSV file to summarize the overall situation on the target. For the situation given above, I would like to write a csv file like the following:

Account1,Group1|Group2

Is there any way to do that, for example using a particular virtual property on the mapping? 

Thanks.

Parents
  • 0 6 days ago

    I think this should work (tested in 9.3)...

    Example: UnsAccountB to CSV

    to the left side UnsAccountB (All)
    Add property: Member of M:N schema types
    Name: vrtGroups
    M:N schema type
    [+] UNSAccountBInUNSGroupB (all)
    OO UID_UNSAcocuntB OO UID_UNSGroupB

    Members: UNSGroupB (all
    Primary key property: CN
    [ok]

    Then this is the big trick!!!
    Create new mapping
    Left: UnsAccountB (All) - Right CSV
    vrtGroups > Groups (this is the columnname in the CSV)

    The Property Mapping Rule Conflict Wizard (pops-up!)

    Choice the second option:
    One of the schema.... Select this option to convert a multi-value schema property...

    Now click on the property 'VRT_vrtGroups' (of type MVP converter) created by the wizard and change the settings

    Name: VRT_vrtGroups
    Data type: String
    (*) Join values
    Source property: vrtGroups
    Delimiter: |
    [ok]

    Now remove the mapping and rename
    property 'VRT_vrtGroups' to vrtGroupsString

    Recreate the mapping.
    Left: UnsAccountB (All) - Right CSV
    vrtGroupsString > Groups

    Good luck ;-)

Reply Children
No Data