Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

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