Data is mentioned in the above table. my requirement is to display separate month columns like jan
feb ........ in output table . plz send me solution.
THE .QVW FILE NOT OPEN IN MY PERSONAL PC SO PLZ EXPLAIN ME
My answer is the same with Satyadev below.
You may have to use loop to separate month in each row.
FOR i = 1 to 3
SubField(Month, ',', $(i)) as Month
Name, Time, Month
raju, 11:30, "jan,feb,march"
suresh, 12:30, "april,may,june"
rajesh, 1:30, "july,aug,sept"
mahesh, 10:30, "oct,nov,dec"
For condition is not needed i guess.
Simple subfield will work fine
SubField(Month, ',') as Month;
LOAD * INLINE [
Try closing the discussion by choosing the right answer, which might be useful in future for the one, who comes in and searches for the same question
Try like this
SubField(Month, ',') as Month
Retrieving data ...