Create new table with no records

[dwighttrumbower]

Is this possible? I want to create a new table in script that data will be added to with cancatenate and in a loop?

WeeklyStreaks:
LOAD
QuotaSalesRegion,
WeekStartDate,
Year,
Week,
Month,
WeeklySales,
WeeklyQuota,
QuotaMetFlag,
0 AS Streak
WHERE 0; // Empty initial table

It does error out. So syntax might not be correct .

[aitho · Accepted solution]

Hi, try this:

WeeklyStreaks:

LOAD

Null() as QuotaSalesRegion,

Null() as WeekStartDate,

Null() as Year,

Null() as Week,

Null() as Month,

Null() as WeeklySales,

Null() as WeeklyQuota,

Null() as QuotaMetFlag,

Null() as Streak

Autogenerate 0;

[dwighttrumbower]

Thank you, that worked.