Extra tables being created when using a preceding load

tinkerz1 — Wed, 25 Nov 2020 16:16:04 GMT

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];

Re: Extra tables being created when using a preceding load

sunny_talwar — Wed, 27 Apr 2016 09:45:00 GMT

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];

topic Extra tables being created when using a preceding load in QlikView

Extra tables being created when using a preceding load

Re: Extra tables being created when using a preceding load