Load inline with "," as a decimal separator

[#1]

I want to do this:

[WhatIfPreço]:
LOAD * INLINE [
 Mudança Preço
 -.2
 -.15
 -.1
 -.05
 -.03
 -.01
 0
 .01
 .03
 .05
 .1
 .15
 .2
];

The problem is that the decimal separator is set to "," as I am in Brazil so that does not work as expected.

The question is: How do i write this when the decimal separator is comma?

[martin59]

Hi,

You have to do something like this :

table:
LOAD Replace([Mudança Preço],'/',',') as [Mudança Preço]
INLINE [
Mudança Preço
-0/2
-0/15
-0/1
...
];

Hope that helps you

[#3]

It worked!

Thank you.

[rwunderlich · Accepted solution]

You can specify the delimiter to be used in the load:

] (delimiter is '|') ;

and then use commas in your data.

[amien]

why not just "2,2" "2,1" etc?

[natalia_sterniak]

Because ',' will be treated as a separator between new dimensions and values