Alteryx workflow not giving the output

[rakeshkumar801]

Hi,

I am facing the issue that RTool. It is not giving output in alteryx workflow. I have attached the input file and workflow.

Regards

Rakesh Kumar

[Emil_Kos]

Hi @rakeshkumar801,

I don't think I can open your workflow properly:

Can you check if it wouldn't start to work if you will change the file path and used create a new sheet(option number 3) instead of owerrighting it. 

I have a feeling it will start working for you if you will make those changes. 

[rakeshkumar801]

Hi,

I am attaching a file containing a screenshot of the workflow and code inside RTool.

Regards

Rakesh Kumar

[danilang]

Hi @rakeshkumar801 

What should the 2 outputs be?

Dan

[rakeshkumar801]

Hi,

If you run the same code in Rstudio importing the input file, Output2 gets 3 records and Output3 gets 1 record from input file.

Regards

Rakesh Kumar

[danilang]

Hi @rakeshkumar801 

For those of us without RStudio installed, can you please provide details as to which records are returned? 

Thanks

Dan

[rakeshkumar801]

Hi,

Please find the screenshot of the outputs in the attached file. Seems to be issue with two lines of R code.

Regards

Rakesh Kumar

[rakeshkumar801 · Accepted solution]

The below code worked for me.

library("data.table")

Input3 <- read.Alteryx("#1")

Input3 <- as.data.table(Input3)