Formula issue - Add columns with number and a space

Question

Dears,

I'm trying to replicate the below formula in the designer without success.

D1&" "&C1

D1 is 1, C1 is 2020. Result has to be: 1 2020

I'm trying to do in Alteryx:  D1 + " " + C1 but it doesn't work and it doesn't read the formula.

How do I solve it?

Thanks a lot for your support

Aaron_Harter · Accepted Answer

@Francesco07,

Your fields are likely a numeric data type, try wrapping each field in the ToString expression:

ToString([fisc_month]) + " " + ToString([fisc_year])

patrick_digan · Accepted Answer

@Francesco07 you may need 2 changes, first you'll want to use tostring([Fisc_month]) and tostring([fisc_year]) assuming they're numbers. Then you'll also want to include a space between your quotes.

tostring([fisc_month]) + " " + tostring([Fisc_Year])

Jonathan-Sherman · Accepted Answer

Hi @Francesco07,

The issue is most likely they aren't both strings, try:

ToString([Fisc_month]) + " " + ToString([Fisc_Year])

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan