topic Re: SQL Topic in QlikView

SQL Topic

srinu1331 — Wed, 08 Aug 2018 10:08:54 GMT

How convert 20k sal into 20,000 in sql server

sibin_jacob — Wed, 08 Aug 2018 10:16:23 GMT

You can use the SQL replace function

SELECT REPLACE('20k', 'k', ',000');

SELECT REPLACE('20k sal', 'k sal', ',000');

srinu1331 — Wed, 08 Aug 2018 10:20:19 GMT

sal is column name

actualdata requirment

sal sal

20k 20,000

10k 10,000

12k 12,000

sibin_jacob — Wed, 08 Aug 2018 10:23:21 GMT

SELECT REPLACE(sal, 'k', ',000') as sal from table1

arvind1494 — Wed, 08 Aug 2018 11:51:41 GMT

did you completed this?

srinu1331 — Wed, 08 Aug 2018 12:54:22 GMT

no i did't get it

arvind1494 — Wed, 08 Aug 2018 13:19:10 GMT

Use following in your load script in qlikview or sense:

load REPLACE(sal, 'k', '000') as sal from database.tablename

el_aprendiz111 — Wed, 08 Aug 2018 15:23:52 GMT

Hi, srinu:

1- option:

LOAD *, KeepChar(sal,'0123456789')*1000 as FieldSal;
LOAD * Inline
[
sal
10k
20k
30k
];