Dear All,
I have a problem building logic in serice studio.
I have two tables where both tables I will group and will merge.
Like the picture below
Help me figure out how I can build that logic.
Best Regards,
Kane
Hi Kane,
Updated for my previous comment:
As I understood correctly, then in aggregate:
1. Add 2 source: Car Entity and Bike Entity
2. Add filter: Bike Entity ONLY WITH Car Entity
join condition: Bike.Color = Car.Color
3. Select Group by Bike.Color
4. Sum Bike.Price (and named it as whatever you wanted)
Cheers,
Khuong
According to your tables, I think you can archive by using aggregate:
1. Join: CarTable WITH BikeTable
2. Group by BikeTable.Color and CarTable.Color. Sum BikeTable.Price
3. Add new attribute for MergeColor =
If(CarTable.Color = BikeTable.Color, CarTable.Color, If(CarTable.Color = "", BikeTable.Color, CarTable.Color))
Note: Using MergeColor to display in UI and Sum of Price.
Hope this helps,
Hi Kane Loony,
You can take 2 sources in the single aggregate manipulate it and use it to show it on UI.
Thanks
Shehroze