How to rectify the null after read the output file .

Hi all,Hope all are great today this is my query of the day

We can add formula using the condition just like add values to a cell it works perfectly ,but i read the output it shows Null.

How can i solve this problem successfully , please help me with this query.

Thank you .

sum.png

after read the output.png

Developer Tools

Accepted answers

All comments

Raj

have you tried with different output file type?

as this should not happen as you have selected the column stating with "=" sign and the excel file is reading it as an incorrect formula.

binu_acs

@Navyasree123 It is working for me

ExcelFormula_060623.yxmd

Navyasree123

Hi @raj,Thank you for reply

Iam using the same output file only , without '=' also it shows same .

Navyasree123

Hi @binu_acs , Thank you

You said correct but Take that output and read the file into input it shows null.

binu_acs

@Navyasree123 That is strange, Can you open the output Excel file, save it again and close it, then try to open in Alteryx?

Navyasree123

@binuacs ,its working i have one more doubt it is not showing the sum value in the sum field ,it shows the formula

shows the formula.png

jdminton

I was able to recreate your issue. I believe it stems from the cells not calculating in Excel until you open and save it in Excel. I'm not certain why Alteryx reads it in as null unless it has do with Microsoft's encoding. Support might want to know about this for future releases.

binu_acs

@Navyasree123 I can see the values after saving to open in alteryx using the input file

Navyasree123

@binu_acsiam attached the file below ,what i did wrong in that

value.png

jdminton

You need the equals sign = in the front, but after it exports to Excel, @binu_acs was saying you need to open and save the file in Excel before bringing back into the input tool in Alteryx.

Navyasree123

@binu_acsFinally I got the correct answer

Thanks for the support

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703