Excel Formula via Alteryx

sebenciven

Good morning.

I would like to construct via the formula tool the following Excel formula:
=RIGHT(A2;7)&" "&(LEFT(B2;3))

I construct the rule as shown in image 1 but when I open it via Excel I get the error present in image 2.

How can I solve the problem?
Thank you

Image1.png

Image2.png

Output

Accepted answers

Gaurav_Dhama_

I tried replicating the same formula and was able to successfully insert in excel. So there’s no issue with the formula I believe.

Few things worth trying.

1.Try creating the excel without these formulas, see if excel still crash or not. If it does then either below point might help or something else is crashing your excel.

2. If you are updating an already existing excel, check if the file is already corrupted. This is something I have experienced before, and was resolved by simply changing the template.

All comments

simonaubert_bd

Hello @sebenciven

I'm not sure it should work...however works pretty well if you save in csv and open it in excel.

The other way would be to create a workflow with maybe some python or R in order to get the exact result.

Best regards,

Simon

sebenciven

Hi @simonaubert_bd

thank you for the answer but it doesn't help me.

There are Excel formula that use fields from another sheet of the same file and when I save .csv file I cannot do any sheet but only one file.

lukas_olsovsky

Hi Sebencieven, can you translate the second picture for me, please?

Gaurav_Dhama_

Try using

=RIGHT(A2,7)&" "&(LEFT(B2,3))

Replaced ";" with ",".

sebenciven

Hi @lukas_olsovsky - Yes of course. Excel removes cells with my formula because He founds an error.

@Gaurav_Dhama_ I trided but Excel give me an error because Excel Formula accept ";" and not ",".

lukas_olsovsky

@sebenciven this error is usually in macro enabled worksheet. Do you have macro enabled in your file/excel setup?

If its not the case, instead of & I would personally use "CONCAT" / "CONCATENATE" - depends on your excel version. CONCAT(RIGHT(A2,7);" ";(LEFT(B2,3))

sebenciven

@lukas_olsovsky I've tried but I have the same result... 😭

Possibile that the problem is the " "?

simonaubert_bd

@sebencivenno, I don't think it's a formula syntax issue because then the file would open with an error in the formula... here, it's more like it doesn't understand it's a formula, maybe an escaping, enclosing something missing.

lukas_olsovsky

@sebenciven did you try to put in front of "=" (formula start)delimiter, which you will put out in excel via "text to columns?" or during .csv import?

Gaurav_Dhama_

xml corrupt error happens when the value populated in excel is not in correct format. Try to run the Alteryx, copy one of the "Formula created in Alteryx flow" and paste it manually in one of the excel file. Does it create the required result without any pop-up warning.

sebenciven

@lukas_olsovsky Hi, it's an excel file not .csv, what delimiter? 🤔

sebenciven

@Gaurav_Dhama_ Formula works corretly if i paste it on excel

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335