Extra tables being created when using a preceding load

[tinkerz1]

Hi,

I have a preceding load that is creating an extra table that I can see in the table viewer, what I am doing is added more lines to the table by grouping and filtering; I am just thinking should I be concatenating the load statement on the preceding load.

ie.

Table1:

Load *,min(A) Resident x group by Y

concatenate

Load * Resident x

I hope this is clear, I want to make sure I dont see a new resident x table, in the table viewer this would be X-1 table, this is saying to me a table has been created.

table_1:
load
'Limit' as [Name_1],
count ([Month of AsOfDate]) as [Count of Month of AsOfDate_1],
[Month of AsOfDate] as [Month of AsOfDate_1]
resident Source_data
where [Month of AsOfDate] >= date('$(vCalenderStartMonthEndDate)','DD/MM/YYYY') and [Month of AsOfDate]<= date('$(vCalenderLastMonthEndDate)','DD/MM/YYYY')
group by [Month of AsOfDate];
load
[Limit Cat ID] as [Limit Cat ID_1],
'Limit' as [Name_1],
date(min([Month of AsOfDate])) as [Month of AsOfDate_1],
min([In Excess]) as [In Excess_1]
resident Source_data
where
[Month of AsOfDate] >= date('$(vCalenderStartMonthEndDate)','DD/MM/YYYY') and [Month of AsOfDate]<= date('$(vCalenderLastMonthEndDate)','DD/MM/YYYY')
group by
[Limit Cat ID],
[Name_1],
[Month of AsOfDate];

[sunny_talwar]

because the above code doesn't seem like preceding load to me (check out the two resident loads below)

table_1:
LOAD
'Limit' as [Name_1],
count ([Month of AsOfDate]) as [Count of Month of AsOfDate_1],
[Month of AsOfDate] as [Month of AsOfDate_1]
resident Source_data
where [Month of AsOfDate] >= date('$(vCalenderStartMonthEndDate)','DD/MM/YYYY') and [Month of AsOfDate]<=date('$(vCalenderLastMonthEndDate)','DD/MM/YYYY')
group by [Month of AsOfDate];
LOAD
[Limit Cat ID] as [Limit Cat ID_1],
'Limit' as [Name_1],
date(min([Month of AsOfDate])) as [Month of AsOfDate_1],
min([In Excess]) as [In Excess_1]
resident Source_data
where
[Month of AsOfDate] >= date('$(vCalenderStartMonthEndDate)','DD/MM/YYYY') and [Month of AsOfDate]<=date('$(vCalenderLastMonthEndDate)','DD/MM/YYYY')
group by
[Limit Cat ID],
[Name_1],
[Month of AsOfDate];