Alteryx - Data massaging

Question

Hello,

If my Data is like this and i want total of last column (wont mind total of all columns) then what is the way to do it in alteryx?

xyz          EQ           1/31/2023       1291722A SDSD6682112.6884986473112.688498647397916423BHJHJ96070.127747473770.127747473769723297CGJGI8068924.289497647424.2894976474979329DIUGI5985172.744747747172.74474774770773070EGKG49543.512874401.1343.512874401.13

ilovecoding · Answer

My source file format is .csv so when i chose select function i see only 2 options rather than several columns. First row contains field names is already checked

binu_acs · Answer

@ilovecoding you can connect your excel input file in the given workflow. If your excel file doesn't have any column heading, use the below option in the input tool

Column_Total_040323.yxzp

ilovecoding · Answer

thanks for response, how did you get Field1 field2 labels? My file doesn't have it and i don't want to write that manually in excel before executing in alteryx