Prevent group by from joining to the main table

[#1]

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

[sunny_talwar]

This:

NewTable:

Load

     field1 as Newfield1,

     Sum(field2) as GroupSumfield2

     Resident [MainTable]

Group by

  field1;