Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a question about group by of repeated values.
I have a table that gives me repeated values, however, I made a relation that A is equal to AA,AB,AC, but when displayed in a table, it shows me A three times (values from AA, AB,AC), but i want to see only one A, but with the sum of AA,AB,AC.
Im using a straight table.
If all of your associations are such that the A = AA,AB,AC and B = BA,BB,BC etc. you should just add a field during load:
Load
....
Left(Field1,1) as Group_Filter
....
from xyz.xls;
or something like that.
If all of your associations are such that the A = AA,AB,AC and B = BA,BB,BC etc. you should just add a field during load:
Load
....
Left(Field1,1) as Group_Filter
....
from xyz.xls;
or something like that.
Did the above poster's response solve your issue? If so, please be sure to click the Accept as Solution or confirm in a chat reply, so we can mark it. If not, please provide further information.
Regards,
Brett