Discussion Board for collaboration related to QlikView App Development.
I like to merge several columns one below the other as follows:
Any idea? Thank you very much for help
I'm sorry for late respond. Thank you for your help. It works fine.
View solution in original post
May be this
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
Start as Node
Where AutoNumber(RowNo(), Case) = 1;
Destination as Node,
DROP Table Table;
Glad I was able to help. Please mark the correct response as the correct answer instead of marking your thank you as correct.