topic Create new table with no records in Connectivity & Data Prep

Create new table with no records

dwighttrumbower — Thu, 10 Apr 2025 19:25:03 GMT

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 .

Re: Create new table with no records

aitho — Thu, 10 Apr 2025 19:41:10 GMT

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;

Re: Create new table with no records

dwighttrumbower — Fri, 11 Apr 2025 13:51:27 GMT

Thank you, that worked.