Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
My data has three columns: VISIT, CONTRACT, ORDER. In data load editor, I want to load this three columns as one column called ACTIVITY. Something like: LOAD (VISIT, CONTRACT, ORDER) AS ACTIVITY. What is the proper grammar?
Thanks!
t:
load * Inline [
col1,col2,col3
A,D,G
B,E,H
C,F,I
];
Load col1 as Final Resident t;
Load col2 as Final Resident t;
Load col3 as Final Resident t;
drop table t ;
result: (per analogy)
Can I do LOAD multiple times with one SQL query?
You'll have to load ur table and then reload from your loaded table (a resident load) as clear in the provided example.
Omer, don't you think this is an option?
Name:
Load
VISIT AS ACTIVITY
From
Load
CONTRACT AS ACTIVITY
From
Load
ORDER AS ACTIVITY
From
Can you share sample data and output?