want to put the formula

[Maheshp]

Hi Team,

I want to apply the formula =LEFT(AC12,LEN(AC12)-6) in Alteryx but it is not working, could you please help us to set the formula.

Raw Data	Required data with the help of formula.
VISA0012251968231002	VISA0012251968

Regards,

Mahesh

[ed_hayter · Accepted solution]

I went with the following formula - I think the only thing wrong with yours was that the function in Alteryx is LENGTH() rather than LEN()

[Maheshp]

Hi Hayter,

Thanks for letting us know, Want to ask one more question.

i want to merge column 1 & 2, with the help of & formula, result should be 3 column.

251970

-29.23

251970-29.23

Regards,

Mahesh

[alexnajm]

You can use a + in the formula tool to create this third column - just note that if you want them to be strings and they are numbers, you need to do ToString([Field1]) + ToString([Field2])

Basically the & in Excel is replaced with the + in Alteryx