hi!
I want to concatenate the strings!
When displaying the time, I want to use "hour" + ":" + "minute"!
Example: "9" + ":" + "15" → 9:15
I'm not good at English, so this may be difficult for you to understand.
Thank you!
Hi @KubotaNatsuki ,
You can achieve this by using & in your expression instead of +, provided all are in text format.
If you have hour and minute in number format, you need to convert it to text by using text function.
Therefore, your overall formula should be text(hour)&" : "&text(minute).
However, it is recommended that you maintain the delimiter in an admin module lineitem, and refer it in your expression. This way you can main consistency, and the performance is not hampered.
Regards,
vinayvm
Hey @KubotaNatsuki ,
Pls go through Operators and constants - Anaplan Technical Documentation this will be helpful for you to have better understanding of how to combine, compare, and perform mathematical or logical operations with your data.
~ Jitendra
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
Would someone advise how to find the App hub. I am following the module directions but I do not see it on my end.
