Why Alteryx reads non-raw information from Excel?

Question

Hi,

I have an unusual default design set in my source excel table: the amount of 43000 code is positive, but when clicking the cell we can see at the function row that the raw amount is negative! (Screenshot attached).

Surprisingly, Alteryx attracts the designed positive amount instead of the negative raw amount.

Do you have any idea how to solve that issue?

Stavi · Answer

Hey,

Thank you !

All the solutions focus on preparation work in the excel file, but since I have over 200 excel files combined together this is not relevant for me

CainãClímaco · Answer

Hi!

I just had to do something like that.

I used the comments in these links.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Preserve-Formatting-on-Overwrite-to-xlsx/td-p/650341

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Preserve-Formatting-and-Write-to-Excel-Range/td-p/539056

I hope it helps.