Output Excel formula

[BrendaRdz]

Dear all,

I am trying to add a new formula where the output in excel will be the formula CONCATENATE, it is not working though.

Here the current formula:

"=CONCATENATE(A"+tostring([data]+1,0)+",B"+tostring([data2])+1,0)+")"

I would like Alteryx to recognize that the execution should be performed per row number.

I am getting a parse error. Hope you can help me with this.

[clmc9601 · Accepted solution]

Hi @BrendaRdz,

Looks like you've just got an extra ) causing the parse error! The unnecessary one is right after '[data2]'.

Here is the corrected version:

"=CONCATENATE(A"+tostring([data]+1,0)+",B"+tostring([data2]+1,0)+")" 

Hope this helps!

[OllieClarke]

Hi @BrendaRdz if you're trying to concatenate in Alteryx, then the function is simply '+'. So your formula tool would be:

"(A"+tostring([data]+1)+"B"+tostring([data2]+1)+")"

Hope that helps,

Ollie