R error when writing to Alteryx

I'm writing a batch macro to parse the scanned pdf files and to write the output for each file to a separate tab in Excel. When the macro was run, it was able to convert the files in the folder it is reading. However, I've encountered this error, Error: R (4): The field layout changed between subsequent calls to write.Alteryx with the same connection (Output1), when it was trying to output to the Excel file.

Can someone help to solve this error and let me know how to write the output for each file to a separate tab in Excel?

2019-10-27 19_33_12-Alteryx Designer x64 - R code in macro_.png

2019-10-27 19_35_14-Alteryx Designer x64 - Read PDF Image batch macro_.png

Output

Parse

Batch Macro

R Tool

Accepted answers

ganesamurthy

Problem is you should convert this text to a dataframe in R code before bringing it to the workflow. Here is the corrected R code:

for (file in files){
pngfile <- pdftools::pdf_convert(file,dpi = 200)
text <- tesseract::ocr(pngfile)
x <- data.frame(text)
write.Alteryx(x,1)
}

Hope this resolves your problem.

All comments

ganesamurthy

Did you modify settings in Interface Designer when output field changes based on configuration or data?

Can you please share me your workflow for further assistance on this?

Thanks.

LFLee

@ganesamurthy , it was a standard macro and i've changed it to iteration macro when I hit the error but it still does not resolve the error. I've attached my workflow here.

Appreciate your help on this.

Read PDF Image batch.yxmc

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335