18 Dijit in QVD

[mert1917]

Hi all,

How can I get the 18 digit numbers to qvd with number format?

unfortunately it does not transform?

can you help me please?

example;

TEST_ID

'999999999888888888'

[zhadrakas · Accepted solution]

maybe this

TEST:
Load num#(INPUT) as NUM,
	 num#(INPUT, '000000000000000000') as NUM18
;
Load '999999999888888888' as INPUT AutoGenerate (1);