topic I need to splitout a data field on data load into two columns in QlikView

I need to splitout a data field on data load into two columns

Tue, 27 May 2014 11:16:10 GMT

I need to be able to split a value in a table to create two fields in my dashboard

i have a field that contains a three digit code and I need to populate the first two digits into one column and the last digit into another column, What is the easiest way to do this

example : X1A

and I need

X1 and A in seperate column

Re: I need to splitout a data field on data load into two columns

Tue, 27 May 2014 11:18:53 GMT

easiest way will be two separate expressions

1; left(Fieldname,2)

2: right(Fieldname,1)

1 takes only the first 2 digits from the left

2 takes only the first digit from the right.

Re: I need to splitout a data field on data load into two columns

ashfaq_haseeb — Tue, 27 May 2014 11:23:21 GMT

Like this.

Temp:
Load * Inline
[
Text
X1A
];


Main:
load *,
Left(Text,2) as F1,
Right(Text,1) as F2
Resident Temp;
drop table Temp;

Regards

ASHFAQ

Re: I need to splitout a data field on data load into two columns

Tue, 27 May 2014 11:27:36 GMT

ay yep...Ashfaq's way will work in Dataload