Hello All,
I would like to update additional decimal for value inside the string how can I implement below logic.
Mismath(FORMATNUMBER(value,'###0.000000'))
How to implement same.
Regards,
Niranjan
Hi @NiranjanK1
One way of doing this.
Many thanks
Shanker V
Step 1: Input
Step 2:
Step 3:
(\d+)(.\d+)
Step 4:
[RegExOut1]+PadRight([RegExOut2], 7, "0")
@ShankerV thank you for quick response.
Actually I have string and number in same field. If merge both string and number format is missing. Thank you
Can you please share the sample input and the output expected.
Thanks in advance.
@ShankerV Here is the example
Input: Mismatch(FORMATNUMBER(value,'###0.000000')
Output:
Mismatch (500.032654)
This is how Output look
have you tried using "ToString(ToNumber([name of coumn containing original value]), "###0.000000")" to bring the value
Hope this help
@Raj I have tried but I'm not getting expected Output
@NiranjanK1 would you be providing the value for the [value] field you mentioned in the below example? May be in a tabular format
@binu_acs value is field name which is having numeric data. Mismatch is string data. But with both of details I want additional decimals for number. It's not working any suggestions how can I add additional decimals. Thanks in advance
@NiranjanK1 I am not sure I understand your requirement properly, based on my understanding I think the amount in your Excel sheet just rounding the numbers into two decimal places, if you open that Excel in Alteryx you will able to see all the digits after the decimal. If this is not something you are looking for then provide some sample data in Excel with output data
@binu_acsHere is the example, Below is the output for im looking
Field1: Mismatch
Field2: Value =500.032654
Function:Field1+Field
Mismatch(FORMATNUMBER(500,'###0.000000')
Final Output:
The final output (string + value) need additional decimal
@NiranjanK1 let me know the below function works for you
