Link multiple columns together in same table

Qlik_ULG — Mon, 19 Feb 2018 15:56:46 GMT

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

Re: Link multiple columns together in same table

jwjackso — Mon, 19 Feb 2018 21:56:12 GMT

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