topic Merge columns in QlikView

Merge columns

Anonymous — Tue, 09 Jan 2018 11:27:12 GMT

Hi all,

I like to merge several columns one below the other as follows:

Original table:

Target:

Any idea? Thank you very much for help

sunny_talwar — Tue, 09 Jan 2018 12:16:59 GMT

May be this

Table:

LOAD * INLINE [

Case, Start, Destination, Distance

C1, N1, N2, 10000

C1, N2, N3, 50000

C1, N3, N1, 60000

C2, N4, N5, 25000

C3, M1, M2, 80000

C3, M2, M3, 70000

];

FinalTable:

LOAD Case,

Start as Node

Resident Table

Where AutoNumber(RowNo(), Case) = 1;

Concatenate (FinalTable)

LOAD Case,

Destination as Node,

Distance

Resident Table;

DROP Table Table;

Anonymous — Fri, 12 Jan 2018 14:55:34 GMT

Hi Sunny,

I'm sorry for late respond. Thank you for your help. It works fine.

Best regards

sunny_talwar — Fri, 12 Jan 2018 14:57:17 GMT

Glad I was able to help. Please mark the correct response as the correct answer instead of marking your thank you as correct.

Best,

Sunny