Hello,
I want to do use some aggregate functions on some fields in my mapping, the target table is as follows
But I get an error while integration, saying that "GROUP BY, à la position 0, n'est pas dans la liste SELECT"
When I check the code generated, I can see the reason why, here is a part of the code generated, the group by part :
group by 0, split_part(date.c2, ':', 2)::date, eb_party.eb_party_num, split_part(carrier.c3, ':', 1), 0, split_part(pickslip.c3, ':', 1), current_timestamp
Can anybody please help me figure out this problem ?