topic Re: Length conversion in QlikView

Length conversion

Vaku1606 — Fri, 01 Jul 2022 19:51:49 GMT

Hello team,

I have 2 formats for length coming from 2 different sources/tables: for example 146.0 and 146 mm. How can I convert 146 mm into 146.0 in order to have the same format and standardization in place?

Thanks in advance and regards

Re: Length conversion

sidhiq91 — Sat, 02 Jul 2022 09:37:35 GMT

@Vaku1606 Please use below expression to get the Length in the desired format. If it resolves your issue like and accept it as your solution.

NoConcatenate
Temp:
Load
Num(Keepchar(Length,'0123456789'),'#,##0.0') as Length;

Load * Inline [
Length
146 mm
];

Exit Script;

Re: Length conversion

Vaku1606 — Mon, 04 Jul 2022 10:12:38 GMT

Thanks a lot, works perfectly