How to add values from different columns of input file and output it USING R ONLY

Question

Hi I am inputting data from an excel file using input tool and connecting it to R. Then I want to take the value from calumn#3 and the value from column#5 and set it equal to "total_value" and and output a new excel file. I am getting error when i run the below code. Do I need to install any packages?

input_file <- read.Alteryx("#1",mode="data.frame")

value_1 = input_file [1,3]
value_2 = input_file [1,5]

total_value = value_1 + value_2

Input file --> input.csv

itemnamevalue_1datevalue_21john12342022-08-035678

Output file --> output.csv

nametotal_valuejohn6912

IraWatt · Accepted Answer

Hey @nkazi01,

Here is one way to do this:

input_file = read.Alteryx("#1", mode="data.frame")

value_1 = input_file[1,3]
value_2 = input_file[1,5]

name <- input_file[1,2]
total_value <- value_1 + value_2

df = data.frame(name, total_value)

write.Alteryx(df, 1)

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

IraWatt · Accepted Answer

Aahhh @nkazi01  I think because your data is CSV the numbers would come in as text/string data AKA not numeric data. This would explain the error. Try adding a select tool before your code and change the data types to integers. I have no installed packages.