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
  • 4
  • 7545

Showing Answers 1 - 4 of 4 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))

  Was this answer useful?  Yes

Reddy

  • Aug 25th, 2023
 

Use Normalize

  Was this answer useful?  Yes

Aditya Kamal

  • Nov 14th, 2023
 

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

  Was this answer useful?  Yes

Ravishek

  • Feb 3rd, 2024
 

Hi Aditya , can you provide actual answer of it?

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions