Separate

[renuka_sasikumar]

Hi,

I have a data

Table A:

Data

A

B

C

DDDD

And now I want the output as

Data

A

B

C

D

D

D

D

Is this possible?

Can anyone help me.

[datanibbler]

Hi Renuka,

I think Subfield is the function you want - look it up in the helpfile, one of its uses is to separate strings into several records. You might have to load the rest first and do that separating part in a separate load - you'll have to try it out a bit.

HTH

Best regards,

DataNibbler

[ogautier62 · Accepted solution]

Hi,

something like this :

tableB:

load mid(Data,iterno(),1) as 'newfield' resident tableA while iterno()<= len(Data)

regards

[Anonymous]

Hi!

Use this:

LOAD

    Data,

    SubField(Data,' ') as test

FROM [lib://Community/308076.xlsx]

(ooxml, embedded labels, table is Sheet1);

[renuka_sasikumar]

Hi,

Thanks for your reply, but your query gives the same output.

I got the answer see the below one

Temp:
LOAD * Inline
[
Data
A
B
C
DDDD
];


Temp1:
load
Mid(Data,iterno(),1) as 'newfield'
Resident Temp
while iterno()<= len(Data);

Drop Table Temp;