Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
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)
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