I have the following data in 3 tables.
I need to map this data to a Json profile that would look something like this:
"includes": ["A", "B"],
The main problem is that if I use a single database profile to join all of this data together it ends up doing a Cartesian join and I end up with duplicates in both the "includes" array and the "locationDetails" array.
What I have tried doing is having my database profile only join the COMM and the COMM_LOC_DETAIL tables together. I then do a separate lookup to the COMM_INCL table and store that in a cache which I then add to the source profile of my map. However, when I map that cache over that ends up giving me duplicates in the "includes" array.
So my question is how can I use the above tables to create the desired Json?