Splitting Single Column into Multiple Columns

[@hemanthuvaraj]

Can you please explain, what if we don't know that cycle value is 4.
Example:
1
Name1
London
GradeA
2
Name2
Dubai
3
Name3
Sydney
GradeB

[@thirumaleshn9589]

Hi , I was asked by one scenario its regarding unpivot i.e. my source i.e. flat file data format change daily base so according it as to unpivot it and load into target. please find the below source and target data. Day 1 source data and expected to load target data as:source data
10 a
10,20,30 b
10 c
Target data load10 a
10 b
20 b
30 b
10 cDay 2 source data and expected to load target data as : source data
10 a
10,20,30 b
10 c
10,20 dTarget data load10 a
10 b
20 b
30 b
10 c
10 d
20 dDay 3, Day 4 and so on source data format getting differently and as per format it as to pivot and load it into target.please help me here how to resolve the scenario.Thanks

[@prasadkumbhar1656]

Hello Sir,
As you said you want for first four record the sequence should be 1,1,1,1 how did you get that logic ??
is the sequence generator start value = 1 incrment by =1 and end value=4 and is cyclic option enabled??

[@25683687]

Superb sir (Y)