Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_ULG
Creator
Creator

Link multiple columns together in same table

Hi,

Is it possible to link multiple columns in a table together? I have a table that has a unique identifier, but all the data is stored in one row, instead of multiple columns.

I have the following columns on the same row. Is it possible to link Action1, DateOpened1, DateClosed1 together and the same to each of the rest?

ID
Action 1
Action 2

Action 3

Action 4

Action 5

DateOpened1

DateOpened2

DateOpened3

DateOpened4

DateOpened5

DateCloseded1

DateCloseded2

DateCloseded3

DateCloseded4

DateCloseded5

1 Reply
jwjackso
Specialist III
Specialist III

If you want to keep all the original records and combine some as keys use "load *,".  If not, just keep the fields you want.

[GiveItAName]:

load *,

Action1&DateOpened1&DateCloseded1 as Key1,

Action2&DateOpened2&DateCloseded2 as Key2,

Action3&DateOpened3&DateCloseded3 as Key3,

Action4&DateOpened4&DateCloseded4 as Key4,

Action5&DateOpened5&DateCloseded5 as Key4;


SQL Select

ID
Action 1
Action 2

Action 3

Action 4

Action 5

DateOpened1

DateOpened2

DateOpened3

DateOpened4

DateOpened5

DateCloseded1

DateCloseded2

DateCloseded3

DateCloseded4

DateCloseded5

from sometable;