An "@" symbol occurring in Excel Formula generated by Alteryx

Question

Hi Everyone,

It's just been a while using Alteryx. I had a requirement to generate excel formulas as an Output in Alteryx. I have done the needed changes for it but the excel formula thats been generated has nan "@" symbol before every sheet name. This is causing the excel to not pick any data. Attaching documents for better understanding

Excel Formula: =SUM(IF((Merival!$G3:$G100000=D2)*(Merival!$H3:$H100000=E2),Merival!$K3:$K100000,0))

Alteryx Generated Output: =SUM(IF((@Merival!$G3:$G100000=D2)*(@Merival!$H3:$H100000=E2),Merival!$K3:$K100000,0))

I see this issue occurring when sheets names are used in formula, it would be great if someone could help me out with this.

Thanks

New Workflow3.yxmd

karlhansen · Answer

This is still happening with Version: 2023.1.1.281 Patch: 3

karlhansen · Answer

I see this happening in Designer version 2023.1.1.123 when used with a certain function (I have not tried it with other functions)

"=@IMAGE..."

DanielG · Answer

@fernanff -- can you load data into a template Excel file where the formulas already exist?  If it is an Office365 issue as @Robin_McIntosh has found, then this might be a way around that.