Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there any way to leverage the transform column function to apply a math operation to the feild in place. I.E. not a new column then delete the orginal then rename the new column as the old.
I have an order form coming in with line numbers that the system treats as a 3 digit line with 3 digits of sub line 001.000. but it really only stores it as 1000.
I feel like transform should be able to apply an operation to a column but just cant find the right way to do it.
Solved! Go to Solution.
Hi,
in trasform use Standard - multiply
then
then you obtain the formatting on the canvas
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
I can't post company data, but pick any column with number values, ie some systems store pennies with no decimals. I would like to convert to dollars without adding a column.
Amount
12345
654321
200
300
should be
Amount
123.45
6543.21
2.00
3.00
Hi,
in trasform use Standard - multiply
then
then you obtain the formatting on the canvas
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
Wow! I knew it was obvious. Just couldn't see what was right in front of me.
Thanks!
Hi,
some sampple data should help resolving the issue
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |