topic 2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10 in QlikView

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

Tue, 25 Jan 2011 21:12:54 GMT

in the Load Statement i can convert the INVHDRI by using char(INVHDRI) and then use a second step of len(INVHDRI,10) to get INVHDI to be character and length of 10.

How can i convert INVHDRI to character and tell Qlikveiw to make the length 10 in one formula instead of two or in one step instead of two steps?

Thank you for you help,

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

hector — Tue, 25 Jan 2011 21:19:23 GMT

Hi, if the field is a number, you can do

num(19,'0000000000')

and this will return 0000000019

is this what are you looking for?

Rgds

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

Tue, 25 Jan 2011 21:28:50 GMT

He'ctor, yes the field is a number. By using your approach then i have no need for the Chr() and Len() combination.

So, num(INVHDRI,'0000000000) should give me INVHDRI as a character filed that is 10 characters long.

I'll try this and post if this doesnt work.

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

Tue, 25 Jan 2011 21:28:54 GMT

He'ctor, yes the field is a number. By using your approach then i have no need for the Chr() and Len() combination.

So, num(INVHDRI,'0000000000) should give me INVHDRI as a character filed that is 10 characters long.

I'll try this and post if this doesnt work.

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

hector — Thu, 27 Jan 2011 20:43:01 GMT

I guess that works, because you don't post anything xD

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

Thu, 27 Jan 2011 21:22:06 GMT

i tried it and it didnt work quite as i has hoped. I have an [ invoice field 1] that is numeric and i have another invoice field that is character [invoice field2].

if [invoice field1] is populated with 123456 then it will show up as 123,456 and [invoice field2] would show up as 123456 but as a character.

i tried to your recommended forumual on [invoice1] by typing num([ invoice field 1],'0000000000')

and the end result was 0000123456 which would not link to [invoice field2] since [invoice field2] would be populated with 123456.

So to rephrase my question, if i know that [invoice field2] is character field and the field is length 10, whcih means there can be up to 10 charachers in [invoice fiel2] but there doesnt have to be 10 characters.

Is there one formula compound formula that i can apply to [invoice field1] that would satisfy the above link issue?

thank you for your input, it is very much appreciated.

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

hector — Thu, 27 Jan 2011 22:10:37 GMT

did you try to use the num() function in both fields?, if the char field has spaces, use something like num(trim(field2),'0000000000')

Rgds

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

Wed, 09 Feb 2011 20:50:10 GMT

would the same approach work to convert a number field into a character field with each record having 12 characters

chr(field),'0000000000')

2 invoice fields from two different tables: INVHDRI is numeric,pkg 12 and DOCINV is character,pkd 10

Miguel_Angel_Baeyens — Wed, 09 Feb 2011 20:59:32 GMT

Hello,

You can use the following in both fields so they will always have the same format and values.

=Text(Repeat('0', 12 - Len(123456)) & '123456')

That will always return a text with leading zeroes as in the example above "0000123456".

Hope that helps.