Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how do I create a single list box from the column values of multiple columns
please let me know
Here it is
SCHOOL:
LOAD * INLINE [
ID, DATE, Subject,Teacher, Class 1, Class 2, Class 3
1, 1/1/2015,Physics, Tom, Vicky, John, Sam,
2,1/2/2015,Math, Eric, Nickr, Vicky, Kevin,
3,1/3/2015,Science, Catalina, Kevin, Zara, Null,
];
CROSSTABLE (Class, Student,1)
LOAD [Class 1],
[Class 2],
[Class 3]
RESIDENT SCHOOL;
Tution:
LOAD * INLINE [
Subject, Date
Physics, 1/2/2015
Math, 2/3/2015
Science, 3/1/2015
];