I was tasked with building a flow that grabs an csv file from one source, transpose some data and then ftp it to another server.
Lets say a csv file is defined as:
What I want to do is convert it to this based on grouping by email
Is this possible? In the FTP source, I have sorting by Email and Grouping by Email. Does it matter if the csv file is not sorted to begin with? I keep reading that if the source is not sorted, the grouping doesnt work? Even if I have Celigo sort it?
In the mapping of the FTP source I do something like this
*.email -> subscriptions.email
*.product -> subscriptions.products[*].product
*.status -> subscriptions.products[*].status
The FTP destination mapping
To top things off, I dont have access to the FTP destination ( its set up in Celigo, but I dont have the creds on me ) so testing this is impossible. I may have to create my own ftp server just to try it out!
Please sign in to leave a comment.