Separate data in 1 column

[Anonymous]

Hi peeps,

Newbie here, please be patient

Can you help me to separate this data into 2 column please...

So, i want to seperate into 2 column : WBS and Sales Order.

WBS is all starting with "B"

Sales Order is all starting with "3"

Cheers,

Aryo

[sunny_talwar]

May be this

LOAD If(Left([WBS/Sales Order], 1) = 'B', [WBS/Sales Order]) as WBS,

     If(Left([WBS/Sales Order], 1) = '3', [WBS/Sales Order]) as [Sales Order],

     ....

FROM ...

[shiveshsingh]

if(left(DataColumn,1)=3,'Sales','WBS')

[jwjackso]

You can use a preload statement:

Data:

LOAD

If(mid(WBSSalesOrder,1,1) = 'B',WBSSalesOrder,Null()) as WBS,

If(mid(WBSSalesOrder,1,1) = '3',WBSSalesOrder,Null()) as [Sales Order];

LOAD * Inline [

WBSSalesOrder

3005225829-000100

3005317005-000100

3005305555-000100

B0OC-0001092.02

3005332068-000100

B0OC-0021373.02

300536392-000100

3005364985-000100

3005444858-000100

];

[devarasu07]

Hi,

you can create like below

Fact:
LOAD [WBS/Sales Order] as WBS INLINE [
    WBS/Sales Order
    300522829-000100
    300317005-000100
    300505555-000100
    B0OC-0001092.02
    BOC-0021373.02
] where [WBS/Sales Order] like 'B*';
Concatenate
LOAD [WBS/Sales Order] as [Sales Order] INLINE [
    WBS/Sales Order
    300522829-000100
    300317005-000100
    300505555-000100
    B0OC-0001092.02
    BOC-0021373.02
] where [WBS/Sales Order] like '3*';