topic Need Subfield load expression for Different formats in QlikView

Need Subfield load expression for Different formats

Mon, 17 Oct 2016 07:55:03 GMT

Hello everyone,

I have 2 different qvd files which have same columns but i need to trim leading two zeros (if it has in the beginning, else load as it is) before joining them. I think i can use SubField function in the load script but none of the formats i specified worked. Following are the data formats from those two files.

TIA,

James

Re: Need Subfield load expression for Different formats

robert_mika — Mon, 17 Oct 2016 07:59:24 GMT

Try

if(Left(yourfield,2)='00',Mid(Yourfield,3,len(yourfield)), yourfiled) as Yourfiled

Re: Need Subfield load expression for Different formats

rubenmarin — Mon, 17 Oct 2016 08:14:14 GMT

Hi James, can you try the Num() function?, ie:

Num(FieldName) as FieldName

To load string and numbers you can use: If(IsNum(FieldName), Num(FieldName), FieldName) as FieldName

Re: Need Subfield load expression for Different formats

sunny_talwar — Mon, 17 Oct 2016 10:20:16 GMT

May be like this:

Alt(Num(Num#(FieldName)), FieldName) as FieldName