Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Load three columns as one

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!

1 Solution

Accepted Solutions
OmarBenSalem

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)

Capture.PNG

View solution in original post

15 Replies
sunny_talwar

May be this

LOAD VISIT&CONTRACT&ORDER AS ACTIVITY

wanyunyang
Creator III
Creator III
Author

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.

sunny_talwar

Three different tables?

wanyunyang
Creator III
Creator III
Author

One table, three columns

zebhashmi
Specialist
Specialist

So you need only one row in your field?

wanyunyang
Creator III
Creator III
Author

I want to get one column with values A,B,C,D,E,F,G,H,I, not ADG, ADH...

zebhashmi
Specialist
Specialist

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

wanyunyang
Creator III
Creator III
Author

The following error occurred:

Field names must be unique within table

zebhashmi
Specialist
Specialist

Name:

Load

VISIT AS ACTIVITY

From

Load

CONTRACT AS ACTIVITY

From

Load

ORDER AS ACTIVITY

From