writing starts with in the script

[clsaulsberry]

i am new to qlikview and I am trying to create a field from another field that says  if this field starts with "2" then display the information as is but if not only show the first 12 characters.

any advice please

[trdandamudi · Accepted solution]

One way is as below:

Data:
Load * Inline [
ID,Type
10,2 First Record data
20,Second record sample data
30,Third record sample data
40,2 Fourth Record Data
50,Fifth record sample data
];

SourceData:
Load ID,
If(Left(Type,1)=2,Type,Left(Type,12)) as Type
Resident Data;

[clsaulsberry]

Thank you

[trdandamudi]

You are welcome...