I built a pipeline with SFTP as the origin. The file I want to recover is an Excel file of around 100000 rows and 100 columns but it doesn't work.
Solved
SFTP to Excel pipeline Error
- Senior Community Builder at StreamSets
- 95 replies
Best answer by Drew Kreiger
Check this page out. Origins cannot process Excel files with large numbers of rows. When an origin cannot process a file in the Excel data format, you can save the file as a CSV file in Excel, and then use the delimited data format to process the file.
- Senior Community Builder at StreamSets
- 95 replies
- Answer
Check this page out. Origins cannot process Excel files with large numbers of rows. When an origin cannot process a file in the Excel data format, you can save the file as a CSV file in Excel, and then use the delimited data format to process the file.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.