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)
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
LOAD
VISIT AS ACTIVITY,
CONTRACT AS ACTIVITY,
ORDER AS ACTIVITY
From
Or Maybe
Name:
Load
VISIT AS ACTIVITY
From
Load
CONTRACT AS ACTIVITY
From
Load
ORDER AS ACTIVITY
From
The following error occurred:
Field names must be unique within table
Name:
Load
VISIT AS ACTIVITY
From
Load
CONTRACT AS ACTIVITY
From
Load
ORDER AS ACTIVITY
From