Load comma separated values into different columns

[#1]

hi all,

I have a column with comma separated values like 1,2,3,4,5,6,7,8,9,10.

Can i separate this values into individuals columns with particular column name.

If possible Can anyone explain how can i do while loading the data.

Regards,

kumar

[#2]

Small clarification!

Does i need to add above both the expression?

If i add i am getting error as "column name should be different".

If i add single i am getting the data in both first column and in last column

[jagan]

Not both, use any one.

Regards,

Jagan.

[#4]

Hi jagan,

If V1 then last value will be added to 1st column and 1st value will be moved to 2nd column,

and in V2 1st value is added to 1st column and 2nd in 2nd column, so i need to add if condition to every expression, instead how can i check the version first and then put in the table.

For example:

if(parser_version=v1){

some expression

} else {

other expression

}

Is am i correct? how can i do this in qlik sense?

[#5]

Thanks jagan helped lot. I got the solution.