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!

15 Replies
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

wanyunyang
Creator III
Creator III
Author

Can I do LOAD multiple times with one SQL query?

OmarBenSalem

You'll have to load ur table and then reload from your loaded table (a resident load) as clear in the provided example.

zebhashmi
Specialist
Specialist

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

qv_testing
Specialist II
Specialist II

Can you share sample data and output?