Excel Formula

Hi,

I had few things on check on excel report that is generated automatically. But when I import that on Alteryx, it shows me the formula for it instead of VALUES.

Could anyone help me with this issue, I need to view values in excel instead of formula.

excel.png

Fuzzy Match

Accepted answers

binu_acs

@restya_raju It seems that you are reading from Sheet1 which is hidden , change the sheet name from the input tool to Report and try again

All comments

binu_acs

@restya_raju How you are seeing the data in the Excel file? are they showing the values of formulas?

restya_raju

In Excel file I can see Values.

binu_acs

@restya_raju Can you screen shot your input file settings

restya_raju

Sure!!

input setting.png

binu_acs

@restya_raju try turn off AMP engine and try again, if that not works provide a sample file for test?

restya_raju

I tried turning off AMP engine, but still I can't see value.

Copy of Posting Dates 14082023.xlsx

binu_acs

@restya_raju It seems that you are reading from Sheet1 which is hidden , change the sheet name from the input tool to Report and try again

restya_raju

I didn't notice that. Now its working, Thank you so much!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703