Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

SharePoint Output tool exporting 0 rows on using YXDB File

BetoZM
7 - Meteor

Hello all!

 

I've come here since I have this problem where using the SharePoint Output Tool to write a YXDB file, comes out with 0 rows but oddly has all columns used.

And if I try CSV file, it writes as it supposed to be without any problem.

 

This is my Workflow at the very end:

Here I have around 1.3 M records, as well with the Output name that, depending on the date, will change the Suffix.

S1.png

And here is the options used for the YXDB file:

S2.1.png

S2.2.png

 

I have the same options to write a file on the CSV Output that will use the column "Output" to change the name. But no matter what options I use, the file comes out with all column names and 0 rows.

 

S5.png

S4.png

 

I hope this has a Solution, since using the Output Tool and waiting for OneDrive to upload the file is very slow.

  

  

1 REPLY 1
messeaj12
5 - Atom

Hey dawg! I had this issue as well.  I had to change all the data types = Fixed Decimal to another numerical type - I went with Double. That seemed to work for me, happy trails.

Labels
Top Solution Authors