Problem with input data format

Question

Hi Community,

I am looking for solution connected with input data format.

As you can see below, my original format of the data looks like this:

but the data inside it is

294182,21

260626,39

224459,65

the custom format in excel is: [$-en-US,1]# ##0 ;(# ##0 );-

Unfortunately, the Alteryx input data tool is not going inside of it and showing only value after formatting without part of data.

Could you please help to clear such format in alteryx? Thanks in advance.

jamielaird · Answer

Hi @MK97pro ,

Gotcha. That's exactly what you should get by default, so back to my original question - are you seeing something different?

Here's how Alteryx will read in the values in your Excel file. As you can see Alteryx is reading in the underlying exact number disregarding any formatting applied in Excel:

MK97pro · Answer

@jamielaird

sorry for interrupting you, but its not the solution of my problem. In my case it should be from 2,952 to 2951515 (ie. to the value from the excel file which is hidden due to custom format.

MK97pro · Answer

Sorry,

you do not catch my request. In below comment I tried to explain the topic again.