topic Re: Need to insert zero values in existing column in QlikView

Need to insert zero values in existing column

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

Hi Friends,

I need one help, i.e. i have two different tables. in table 1 column value is like this T0000451 and another table column value is like this T451. my question, is it possible to create a column from second table like this T0000451. that means i want to add zeros values in second table. i am giving sample inputs. Thanks in advance

Given Inputs:

Column 1	Column 2
T0000451	T451
T0000452	T452
T0000442	T442
T0000453	T453
T0000531	T531
T0000532	T532
T0000533	T533

Expected Output:

Column 1	Column 2
T0000451	T0000451
T0000452	T0000452
T0000442	T0000442
T0000453	T0000453
T0000531	T0000531
T0000532	T0000532
T0000533	T0000533

Re: Need to insert zero values in existing column

Frank_Hartmann — Tue, 10 Sep 2019 08:43:18 GMT

in script something like this:

~~left(Column2,1)&'0000'&right(Column2,3) as NewField~~

left([Column 2],1)&'0000'&subfield([Column 2],'T',2) as NewField

hope this helps

Re: Need to insert zero values in existing column

StarinieriG — Tue, 10 Sep 2019 09:19:17 GMT

Hi,

you could try in this way:

Replace(Column2,'T','T0000')

Re: Need to insert zero values in existing column

barakovskikh — Tue, 10 Sep 2019 10:40:01 GMT

'T' & Num(Keepchar(Column2,'0123456789'),'0000000')