topic Re: writing starts with in the script in QlikView

writing starts with in the script

clsaulsberry — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: writing starts with in the script

trdandamudi — Wed, 08 Aug 2018 19:08:22 GMT

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;

Re: writing starts with in the script

clsaulsberry — Thu, 09 Aug 2018 13:22:33 GMT

Thank you

Re: writing starts with in the script

trdandamudi — Thu, 09 Aug 2018 16:19:23 GMT

You are welcome...