Formula issue - Add columns with number and a space

[Francesco07]

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 solution]

@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 solution]

@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 solution]

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

[Francesco07]

Thanks to all guys to the quick and successfull feedback!

I really appreciated!

Issue is solved