cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
blitz45
Asteroid

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

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
blitz45
Asteroid

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

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,

 

fmvizcaino
17 - Castor

Re: Error message "Too many fields in record" using Dynamic input and Directory

Hi @blitz45 ,

 

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

fmvizcaino_0-1600811760361.png

 

Best,

Fernando Vizcaino

 

Re: Error message "Too many fields in record" using Dynamic input and Directory

@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. 

Re: Error message "Too many fields in record" using Dynamic input and Directory

Hi @blitz45 ,

 

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

fmvizcaino_0-1600878992698.png

 

 

Best,

Fernando Vizcaino

Re: Error message "Too many fields in record" using Dynamic input and Directory

@fmvizcaino I see it now! Thank you!