Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i need a answer for this,
i am loading three fields from qvd , one of the field having both numeric and char but i want to display only numeric values .
LOAD [SHIP REGISTERED IN],
[VESSEL NAME],
[Container Number]
this is my fields and [Container Number] i want to display this field .
Use KeepChar([Container Number], '0123456789')
LOAD ...
FROM...
WHERE IsNum([Container Number])
Create a new field in the script for that
LOAD ...
If(IsNum([Container Number]), [Container Number], Null()) AS [Container Numeric Only]
...
LOAD *,
KeepChar([Container Number], '0123456789') AS [Container Number Only]
FROM ...
Note that this will create a new field with only the numeric values from [Container Number], so in your examples, this field will store "226073" and "606255".
Use KeepChar([Container Number], '0123456789')
LOAD ...
FROM...
WHERE IsNum([Container Number])
Create a new field in the script for that
LOAD ...
If(IsNum([Container Number]), [Container Number], Null()) AS [Container Numeric Only]
...
Hi Miguel,
thanks for your support ,but still i did not get the answer, please check my code once . [Container Number] values are like this TGHU226073 ,LTIU606255
i want to display only numeric values.
//load * where [Container Number]= KeepChar([Container Number],'0123456789');
LOAD [SHIP REGISTERED IN],
[VESSEL NAME],
[Container Number]
//iF(IsNum([Container Number]),[Container Number],null()) as number
FROM
[C:\Users\srinivasu\Desktop\Qlikview files\Folder Structure\FDS\Extract_QVD\Shiprereg.qvd]
(qvd)
Where IsNum([Container Number]);
LOAD *,
KeepChar([Container Number], '0123456789') AS [Container Number Only]
FROM ...
Note that this will create a new field with only the numeric values from [Container Number], so in your examples, this field will store "226073" and "606255".
Thank u Miguel i got answer.