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?
May be this
LOAD VISIT&CONTRACT&ORDER AS ACTIVITY
If VISIT has A,B,C, CONTRACT has D,E,F, ORDER has G,H,I, LOAD VISIT&CONTRACT&ORDER AS ACTIVITY will generate 3*3*3 (ADG, ADH...) results. I want it to be A,B,C,D,E,F,G,H,I.
Three different tables?
One table, three columns
So you need only one row in your field?
I want to get one column with values A,B,C,D,E,F,G,H,I, not ADG, ADH...
Maybe you are looking to concatenate the fields
VISIT AS ACTIVITY,
CONTRACT AS ACTIVITY,
ORDER AS ACTIVITY
VISIT AS ACTIVITY
CONTRACT AS ACTIVITY
The following error occurred:
Field names must be unique within table
load * Inline [
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?
Try CONCAT function
Can you share sample data and output?
Retrieving data ...