Hi all,
I will try easymorph to know if it is the best tool to transform excel table...
1st question, I want to put a % on results of "Calculate new colums", but I failed...could you help me ?
Kind regards,
XP
Hi Pradelles,
You can click on the column you are targetting and go to the go toward the top banner. There is a selection to apply formatting to the column and % is one of the options. It is just formatting, and the underlying value will still be the same. It looks like this image.
Alternatively, you keep the base formatting and modify the column with an expression and concatenate a string value of "%" to the column value holding the percentage. However, this will change the data type of the column to a string and you will no longer be able to do math on it unless you disable this action or do more transformational actions down stream. I would only recommend this if you feel comfortable with the final state of the column.
That would look something like this.
3 Likes
Thank you a lot !!!
My pleasure! I hope you end up loving Easymorph as much as I do. Have an awesome day.
2 Likes
Definitively +1 (at least 
).
I never worked with any other software having that much fun in creating new stuff.