Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Earn txt file's names and its delimiter in a directory

Saraabdi955
8 - Asteroid

Hi,
I have a large number of text files in a folder, each with separate columns. I want to get list of names of all the files and its delimiter to be written in a different column.
Please help me how can I do this?

11 REPLIES 11
DavidP
17 - Castor
17 - Castor

@Saraabdi955 could you attach a file like that so that I can see what's happening?

 

Saraabdi955
8 - Asteroid

Hiو @DavidP 
In this case, even if the limiter has a problem, the first line that is read enters the database.

I think its because of first step: 1 Record Limit set to 1.

How can I prevent even the first line from entering the database if the file has a problem?

Labels