topic Re: Split values in loadscript in QlikView

Split values in loadscript

Wed, 09 Apr 2014 14:03:56 GMT

In my loadscript i want to load the first digits to one value and the rest to another.

123456789000 should become

123456 (value 1)

789000 (value 2)

I've a fixed limit should always be the first 6 didigts to value 1 and the last to value 2

Wed, 09 Apr 2014 14:06:47 GMT

left(value,6) as value1,

right(value,6) as value2

Wed, 09 Apr 2014 14:12:13 GMT

Ok so in Load script it should be if my table are named "Order_number"

Order_number left(value,6) as value1,

Order_numver right(value,6) as value2,

or is it

left(order_number,6) as value1,

right(order_number,6) as value2,

Wed, 09 Apr 2014 14:14:02 GMT

load left(order_number,6) as value1,

right(order_number,6) as value2

MK_QSL — Wed, 09 Apr 2014 14:22:11 GMT

Left(Order_number,6) as Value1,

Right(Order_number,6) as Value2