Reflecting different types of Values

[Devika]

Hello,

Wanted you help to reflect the same data in Column our Value and CP Value .

When used VW string the value gets changed , % and decimals are not captured the same as in input file .

Please refer to the second table where instead of -0.2500% its reflected as 2.5000000000000001E-3 in the output file 

Counterparty	Break Date	Our Value	CP Value	Break Label
Devika	28-May-21	-0.2500%	0.0600%	Rate
Devika	28-May-21	-0.2500%	0.1000%	Rate
Bhavini	8-Jun-21	0.35	0.1	Fee Rate
Devika	8-Jun-21	EUR	USD	CCY
Bhavini	10-Jun-21	1.0850	1.0111	Price
Bhavini	15-Jun-21	-733,000	-383,000	Quantity
Devika	16-Jun-21	800		Unmatched
Bhavini	15-Jun-21	-107,744  @ 0.25% -993  @ 0.15%	-108,737  @ 0.25%	Fee Rate

Counterrparty	Break Date	Our Value	CP Value	Break Label
Devika	28-May-21	2.50E-03	1E-3	Rate
Devika	28-May-21	-2.5000000000000001E-3	1E-3	Rate
Bhavini	8-Jun-21	0.35	0.1	Fee Rate
Devika	8-Jun-21	EUR	USD	CCY
Bhavini	10-Jun-21	1.085	1.0111	Price
Bhavini	15-Jun-21	-733,000	-383,000	Quantity
Devika	16-Jun-21	800		Unmatched
Bhavini	15-Jun-21	-107,744  @ 0.25%	-108,737  @ 0.25%	Fee Rate

[mbarone]

Not sure I understand.  Can you provide more detail?

[Devika]

Hello Thanks for taking up my query just modified the query adding few details . Let me know if you would require any more @mbarone 

[mbarone]

Do you have a screen shot of your tools and configurations?  Or maybe a sample module you can attach?  Still not following.

[hroderick-thr]

Is this a question for Connect ?  It looks better suited for Designer.

Maybe this will give some ideas. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-show-2-decimal-places-ONLY-when...

In addition to the solution reply, there's another suggestion for converting it to a string

[danilang]

Hi @Devika 

If I copy the data from the table above and paste it into a text input tool, I get exactly what is shown, after accounting for the carriage return in the last line.  Is your data input from Excel?  If so, please attach the excel file.  If the cells in the excel file are  formatted to display the values in this way, the formats are not read by Alteryx.  Only the underlying data is transferred.

Dan