How to convert single row to two columns

Hi,
I have a data like 1,a,b,c,2,d,e,f,g
required output is in two fields:
field1,field2
-----------------
1,a
1,b
1,c
2,d
2,e
2,f

Interview Candidate
Nov 18th, 2022
10
18774

Abinitio

Answer

Showing Answers 1 - 10 of 10 Answers

suresh

Apr 21st, 2023

length: string_lenth(in.field)-1
normalize: string_concate(string_substring(in.filed,1,1),(string_substring(in.filed,2+index,1))

Reddy

Aug 25th, 2023

Use Normalize

Aditya Kamal

Nov 14th, 2023

Normalize everything based on comma, Reformat compare string is numeric then num else last num, Filter num!=string

Ravishek

Feb 3rd, 2024

Hi Aditya , can you provide actual answer of it?

Yash Chaudhari

Jan 15th, 2025

Use only 2 components
IP ---> REFORMAT ----> FBE ----> OP
in reformat
transform:
/*Reformat operation*/
let string("") f_num = "0";
out::reformat(in)=
begin
if(string_is_numeric(in.str)) f_num = in.str;
out.num :: f_num;
out.str :: in.str;
end;
FBE (select_expr):
string_is_alphabetic(str)