Thousand separators with a period | Community
Skip to main content
March 10, 2020
Solved

Thousand separators with a period

  • March 10, 2020
  • 1 reply
  • 2341 views

Hello there, 

 

It seems I am experiencing several issues related to enabling thousand separators for numeric fields. The fields are based on a load file in which I am using floats with double precision and for every variable I enabled decimal & thousand separators (where applicable). However it seems that the extract file's number format overrules any settings done in the load file node. However, the extract file's option for thousand separation does not offer an option to choose the method of separation (e.g. a period). I think this is the reason why my output currently looks like this:

 

 

Load file configuration

 

Extract file configuration

 

Is there any way I can get '198.863,64' as output? In addition, why are the extract file settings generalized over all (numeric) variables? The problem we also run into is that enabling a thousand separator in the extract file also affects the customerid and other numeric variables which should not be separated. 

 

Any help is kindly appreciated. 

 

Kind regards, 

 

Max

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sukrity_Wadhwa

Hi @gravemind_iv,

 

Sorry for the delay in response. I am not very sure but I think your issue might lie with configuration of the extract file activity. There is a documentation on File Extraction that can help here.

 

Hope this helps.

 

Best,

Sukrity 

1 reply

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity ManagerAccepted solution
Community Manager
April 10, 2020

Hi @gravemind_iv,

 

Sorry for the delay in response. I am not very sure but I think your issue might lie with configuration of the extract file activity. There is a documentation on File Extraction that can help here.

 

Hope this helps.

 

Best,

Sukrity 

Sukrity Wadhwa