Flatten/Transpose Data (3 replies)
Hello,
I'm afraid your post has lost its formatting could you perhaps forward and example with screenshots to [email protected]?
Thanks
Scott, here's how to solve your issue.
- You need a hierarchy where the children are each of the image records (this should be quite simple as you setup the hierarchy using the SKU field).
- In a Map transform following the Hierarchy transform create a new field (let's call it Images) with the following formula.
Concatenate("image", "imagedetailrecordid", ";")
Concatenate("image", "imagedetailrecordid", ";")You'll be able to find more info on the Concatenate function in the Appendix of the User Guide (in Aggregate functions).
I will close off the support ticket.
Thanks
Closed due to inactivity.
I have been trying to get Iman to consolidate the following data through both aggregate hierarchical/aggregate methods but am having difficulty understanding how this can be achieved with Iman. The issue is the data is not numerical so I don't have suitable aggregate functions available to me. I have thought of possibly using SQL but also face issues of how to format the data in Iman.
I have data in the following format;
sku image position entity
5055396138016 /h/o/holding-432_1_1_1.jpg 2 4494
5055396138016 /m/a/main-432_2.jpg 3 4494
5055396138016 /t/i/tip-432_2.jpg 4 4494
5055396138016 /b/o/box-432_2.jpg 5 4494
I need to get the data in this format;
5055396138016 /h/o/holding-432_1_1_1.jpg;/m/a/main-432_2.jpg;/b/o/box-432_2.jpg;/t/i/tip-432_2.jpg 4494
Can this be achieved using Iman and if so what is the best method?
Thanks