My code in Alteryx RTool is not producing the output.

Input <- read.Alteryx("#1")  # Even tried using this to change input data to data frame.Input <- read.Alteryx("#1", mode="data.frame") 

print(Input)                 # The input data is printed.

Output1 <- Input[Input$My_MONTH==max(Input$My_MONTH)-1 & !Input$CASE_ID %in% Input[Input$My_MONTH==max(Input$My_MONTH)-2,c("CASE_ID")],]
Output2 <- Input[Input$My_MONTH==max(Input$My_MONTH) & !Input$CASE_ID %in% Input[Input$My_MONTH==max(Input$My_MONTH)-1,c("CASE_ID")],]

write.Alteryx(Output1,2)
write.Alteryx(Output2,3)

The problem is Output1 and Output2 do not get any data.

• r
• alteryx