How to format dynamic columns output after transpose?

[bj6192]

Hi All,
We use transpose to display our result like below sample;
item 2017/11/01 2017/11/02 2017....
a 10000.01 20000.1 ....
b 300.05 5000.1 .....

We need show the result like this;
item 2017/11/01 2017/11/02 2017....
a 10,000 20,000 ....
b 300 5,000 .....

And when we format the result before the transpose command, the output after
transpose will return the original output. Does any command or method to meet
our require?
Thank You.

[kamlesh_vaghela · Accepted solution]

HI

Can you please try below function to format count.

YOUR_SEARCh | eval YOUR_NUMERIC_VALUE=tostring(YOUR_NUMERIC_VALUE, "commas") | transpose

Thanks

[kamlesh_vaghela]

Hi @bj6192,

Have you found your answer?

[bj6192]

Thank you. It work now.