Hi All,
I have a source table(DB - source) with records. I need to create the same table(table structure) in my destination without any records.
I created Output tool with create table, it's inserting records as well.
I tried limiting records in source but it's of no use.
Can any one please suggest any better approach?
I need to accomplish this without any "CREATE" statement.
TIA
Solved! Go to Solution.
Hey @cvalteryx
The "Create New Table" option in the Output Data Tool will do what it says without the need to use a CREATE statement.
If your intended output table schema is the same as the source table, this might work:
1. Stream source table into Alteryx using a LIMIT 1 query (image example below)
2. Use the Sample Tool to Skip 1st Row of Data - this will give you an empty table in Alteryx
3. Use the Output Data Tool to Create a New Table in your DB
Hi
I am trying to create temp table, insert Ordernumber via csv.file
I am not able to insert ordernumber
Temporary table : mytable_order
Empty field : ordernumber
I am getting error while inserting
CREATE VOLATILE TABLE mytable_order, LOG
(
Ordernumber VARCHAR(17)
)
ON COMMIT PRESERVE ROWS;
INSERT INTO mytable_order
VALUES ('55555555555555555')