1T - CSV Creator

[kendevops]

I am trying to figure out a way to get the data for a particular campaign in this export csv. This is what i have in the repeating group, I can be able to get a particular Product based on the constrain of the Product Campaign. But when i want to create the csv using the T1’s Creator CSV Plugin how do i get the data for a particular campaign’s product that is in relative to the campaign of that row? Like i did on the repeating group.

In the CSV export you can see that i get the others from the repeating group

But i can only get the first item here.

How can i do it so i can get all the items for that products’s campaign?

I have tried “is in” and the data is returned but not in same row as with the Campaign name of that particular product.

Please who knows the best way to get this sorted?

[hi.luisacosta]

I’m not sure of your data structure but if I assume correctly that you can search for Products via the Campaign’s Unique ID then you can try this

Repeating Group’s > Campaigns > each item’s unique_id :formattedastext

A new window will appear

In the top section you can now use “this text” which is your campaign’s Unique ID to search for the product names you need so,

So a search for Products (use your constraints) and return a list of Names. This means that for each Unique Campaign ID you returned, you will get a list of product names.

Lastly, in order for that to be formatted correctly, set the delimiter as ;;; or +++

This will ensure that you essentially get a something like this

[Apples,Oranges,Mangos] ;;; [Candy,Chocolate,Cookies]

In this example the first 3 items belong to the first campaign ID.

Final step; use :split by and set it to the delimiter you used which is ;;; in my example

[kendevops]

@hi.luisacosta

+++

Thank @hi.luisacosta this worked