delimiters

[shivamkedia]

i have a data like this:

COLUMNNAME1

s|H|I|V|A|M

i want like this

columnname1

s

h

i

v

a

m

(i want s,h,i,v,a,m in diferent rows.)

[JordyWegman]

Hi,

What is the source of this, CSV?

If it is CSV, then you can load it with delimiter the piping symbol. Then do a  generic load (see link) 

Jordy

Climber

[shivamkedia]

source:
load * inline [
c1
shivam|anurag|ayush
Tanuj|mohit|aryan
]

want solution like this:
shivam
anurag
ayush
tanuj
mohit

[JordyWegman · Accepted solution]

Hi,

This solves your problem:

source:
CROSSTABLE ([source.Attribute field],[source.Data field],1)
LOAD
	[C1],
	[one],
	[two],
	[three]
;
Load
 Subfield(C1,'|',1) as one,
 Subfield(C1,'|',2) as two,
 Subfield(C1,'|',3) as three,
 C1
;
load * inline [
C1
shivam|anurag|ayush
Tanuj|mohit|aryan
]
;

FinalTable:
Load
	[source.Data field] as C1
Resident source;

Drop table source;

Paste this in your script and run a test.

Jordy

Climber