Now and again, you might obtain a request to combination knowledge inside an Adobe Marketing campaign Basic workflow. Nevertheless, when you group by one thing aside from the focusing on dimension, you might encounter an error resembling “‘w0.iid’ should seem within the GROUP BY clause or be used as an combination operate.
The explanation behind Adobe Marketing campaign all the time including the first key to the SELECT clause, in combination queries, stays unknown. Nevertheless, we should discover workarounds to take care of this example. In case you can’t keep away from grouping by the focusing on dimension, here’s a repair for you:
Please observe that this selection is simply out there within the question exercise and can’t be discovered within the enrichment characteristic.
- In question
Add knowledge– create as many aggregates as you need use group by examine field the place wanted.
- Save add knowledge modal window if you end up executed.
Edit extra knowledge– on the underside part you will notice
- In Superior parameters examine following possibility – Disable computerized including of the first keys of focusing on dimension.