How do I get amount field data (string)into comma seperated in numerical format.

[PatilAmar]

Hello folks, I need help for my current assignment.

I have used logic for getting amount number( ex number is 134567  I want that number 1,345.67 in this format) So I used  ToString(ToNumber([payment amt]),2,1,".") this in  formula tool,  I am getting the exact output like 1,345.87 but because of string datatype the amount data I am getting in left aligned. My question is how can I format the number to use of 1000 seperator(,) and decimal places in xlsx. In short after formatting the value I want the data in right aligned with proper amount format(comma seperated and decimal).I tried this by using table tool but I have to give file name in current date format as a  suffix of a file

[binuacs]

@PatilAmar , the table tool should work, what issue are you facing with the table tool? 

[PatilAmar]

Thanks for quick reply yeah I know it's working with table tool but I have to give file name dynamically when we generate the report that date I have to give in suffix of file name. By table tool it's not possible.

[Qiu]

@PatilAmar 
Check the reply here for how to dymically output file name.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/dynamic-output-filename-on-Ren...

A quick sample as below.

[PatilAmar]

Yeah now I am able to create dynamic file. But in output file I observed column names are changed suppose for Payment Date column I am getting Paymen Date as a name of header. How can I fix this?

[binuacs]

@PatilAmar can you screen shot your issue ?