topic Re: appending values to id in QlikView

appending values to id

vinod2086 — Wed, 20 May 2015 09:25:57 GMT

Hi all

I have ID column in that column when Id beginnings with 9 then i need to append 0 , remaining IDs i dont want to change

ID
3456 9123 9876 3456 8765 345 98776

3456

9123

9876

3456

8765

345

98776

i have applied condition if ( not IsNull( ID),'0'&ID) it appending all values

Re: appending values to id

awhitfield — Wed, 20 May 2015 09:31:39 GMT

HI Vinod,

that may be easier to do in the load script, are you trying to add to ) to the start or end of the ID?

Andy

Re: appending values to id

anbu1984 — Wed, 20 May 2015 09:32:03 GMT

T1:
Load If(ID like '9*', '0'&ID,ID) As ID Inline [
ID
3456
9123
9876
3456
8765
345
98776
];

Re: appending values to id

jsanchezh — Wed, 20 May 2015 09:32:22 GMT

Try with the left function:

if(left(ID,1)='9', '0'&ID, ID) as ID

Re: appending values to id

jagan — Wed, 20 May 2015 09:37:06 GMT

HI,

Try like this

LOAD

If(Left(ID,1)='9', '0' & ID, ID) as New_ID

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: appending values to id

amit_saini — Wed, 20 May 2015 09:39:48 GMT

Vinod,

Try this in calculated expression:

=if(Left(PLANT, 1) = '9', '0'&PLANT, PLANT)

Thanks,

Re: appending values to id

vinod2086 — Wed, 20 May 2015 10:32:57 GMT

instead of using like i have used match function its working fine

if(WildMatch(ID,'9*'),'0'&ID,ID)

Re: appending values to id

Wed, 20 May 2015 10:41:20 GMT

this one works

if(WildMatch(ID,'9*'),'0'&ID,ID)

Re: appending values to id

jagan — Thu, 21 May 2015 03:58:31 GMT

Hi,

You can also achieve the same by using Left() like below

If(Left(ID,1)='9', '0' & ID, ID) as New_ID

Regards,

Jagan.