Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Error message "Too many fields in record" using Dynamic input and Directory as my Input

blitz45
8 - Asteroid

I can't figure out why I am not able to see the data once I call out which record I want using the directory tool. In the dynamic input tool, I had already created a template in .csv format because the file i am trying to open every week would be in csv format. This workflow will be ran weekly and I am trying to get the most updated csv file. Below is an example of my workflow and setting from the Dynamic Input tool. How do I resolve this issue? The error message I am getting is "Too many fields in record #1796"

 

Thank You,

 

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @blitz45 ,

 

Probably you need to choose the correct delimiter or to make your field length bigger.

fmvizcaino_0-1600811760361.png

 

Best,

Fernando Vizcaino

 

blitz45
8 - Asteroid

@fmvizcaino  , How do I find that setting since I am not using the "Input Data" Tool? I am using the "Directory Tool" to automatically get the file. 

fmvizcaino
17 - Castor
17 - Castor

Hi @blitz45 ,

 

It is in your dynamic input tool, in your Input Data Source template.

fmvizcaino_0-1600878992698.png

 

 

Best,

Fernando Vizcaino

blitz45
8 - Asteroid

@fmvizcaino I see it now! Thank you!

Labels