My code inRTool 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) [ Attachment Invalid Or Does Not Exist ]
The problem is Output1 and Output2 do not get any data.
https://coursedrill.com/alteryx-training