Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Kindly please share the value should in vertically.
Ex:
Year
2014,2015,2016
O/P
2014
2015
2015
Thanks
Use
Concat(Year,Chr(10))
Great help,Thanks you
Please close this thread by flag Correct answer. And i recommend you to search on community rather creating the Thread
Hi,
If it's in a script, then as an variant
Table1:
LOAD*Inline
[Year
'2014, 2015, 2016'
];
Left Join
LOAD*,
SubField(Year, ',', IterNo()) as NewYear
Resident Table1
While IterNo() <= SubStringCount(Year,',')+1;
Drop Field Year;