Concat string column in integer along with % sign

Question & Answer
, ,
1

ifelse(
sum({m_s})=4 or sum({m_s})=7,
concat(“(n=” , toString(sum(Integer)), “)”),

sum({m_s})=2,
toString(sum(Integer)),

sum({m_s})=1 or sum({m_s})=3,

concat(
formatDate(parseDate(concat(
substring(toString(sum(DATE2)), 1, 4), ‘-’,
substring(toString(sum(DATE2)), 5, 2), ‘-’,
substring(toString(sum(DATE2)), 7, 2)
), ‘yyyy-MM-dd’), ‘MMM-dd-yyyy’),
’ - ',
formatDate(parseDate(concat(
substring(toString(sum(DATE2)), 9, 4), ‘-’,
substring(toString(sum(DATE2)), 13, 2), ‘-’,
substring(toString(sum(DATE2)), 15, 2)
), ‘yyyy-MM-dd’), ‘MMM-dd-yyyy’)
),
concat(toString(sum(Integer)),“%”)
)

this is the code which i written but anable to add sig(string) colum in last concat can u plz help me with that

2

Hi @Siddhi_21 ,

Not sure what issue you are facing but are you not able to edit the last line of this to:
concat(toString(sum(Integer)),“%”, sig(string))?

Feel free to provide more details regarding the problem, otherwise hope this helps!

3

Sig is already a string…but not able to concate it with -
Last concate statement

4

@Siddhi_21,

What error are you getting when you add “sig” to the concat? I see that you are aggregating all the columns with sum and concatenating with static strings. Not sure what “sig” is or how are you calculating it, but if it is related to the same rows you are aggregating then you might need to aggregate it too in order to add it to the formula.

Hope this helps.

5

Date -12 digit integer to a date conversion - #11 by Siddhi_21…

this is the sample file i simple want to concate inter colum with sig column with %

6

ifelse(
sum({m_s})=4 or sum({m_s})=7,
concat(“(n=” , toString(sum(Integer)), “)”),

sum({m_s})=2,
toString(sum(Integer)),

sum({m_s})=1 or sum({m_s})=3,

concat(
formatDate(parseDate(concat(
substring(toString(sum(DATE2)), 1, 4), ‘-’,
substring(toString(sum(DATE2)), 5, 2), ‘-’,
substring(toString(sum(DATE2)), 7, 2)
), ‘yyyy-MM-dd’), ‘MMM-dd-yyyy’),
’ - ',
formatDate(parseDate(concat(
substring(toString(sum(DATE2)), 9, 4), ‘-’,
substring(toString(sum(DATE2)), 13, 2), ‘-’,
substring(toString(sum(DATE2)), 15, 2)
), ‘yyyy-MM-dd’), ‘MMM-dd-yyyy’)
),
concat(toString(sum(Integer)),“%”)
)

this is the code i had written

7

Hi @Siddhi_21,
It looks like you’ve created another post regarding the same topic. Per community guidelines, please try to avoid creating duplicate posts regarding the same question/topic so that it’s easier to keep all relevant information organized for the users aiming to assist.

To limit the number of duplicate responses, I’ll go ahead and archive this post. For all future correspondence regarding this topic, please provide responses on the most current topic, which is linked here.

Thank you!