Strange behavior Inline load

[#1]

Can someone explain this?

LOAD * INLINE
[Name, Value
Name1, "0000"
Name2, "00000000000000"
];

Results in:

And

LOAD * INLINE
[Name, Value
Name1, "0000"
Name2, "0000000000000000"

];

Results in:

Is there a reason for this behavior?

[#2]

Hi swuehl,

Thanks for your reply.

Your solution works. I'm converting data from a legacy system with poor data definitions. Thats why I have to use variables.

[#3]

Hi, Please ignore my last post. Please find the below piece of sample code:

LOAD ID, NAME, NUM(VALUE ,'000000') AS VALUE INLINE [

ID, NAME, VALUE

1, N1, 0

2, N2, 10

3, N3, 101];