Hello all,
When using group by, how can i change the field name that I'm grouping by in the new table so that the new table is not joined to the main table? I don't want them to be connected, just want the new table as a separate table.
NewTable:
Load
field1,
Sum(field2) as GroupSumfield2
Resident [MainTable]
Group by
field1;
Now the new table has field1 and GroupSumfield2, but I want it to have field1 renamed as a new name so that it's not joined to my MainTable.When I also do field1 as field1new then the sum doesn't work appropriately and it created many records from each record not sure why
