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 DataRequired data with the help of formula. VISA0012251968231002VISA0012251968 Regards, Mahesh

want to put the formula

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

Custom Tools

Accepted answers

ed_hayter

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()

Length calc.yxmd

All comments

ed_hayter

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()

Length calc.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703