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.

BLANK TEXT FILE

Yuvaraj85
7 - Meteor

If the text is not having any data then that text file need to be skipped and rest of the text files need to be parsed. Please help me on this

18 REPLIES 18
Yuvaraj85
7 - Meteor

It is working fine but the LF tab is not creating with the headers provided in the layout

jdminton
12 - Quasar

@Yuvaraj85 If you are not seeing headers, it is an issue with how your template is configure in the dynamic input tool.

 

I can see that you are trying to use *LF* in the Input Data Source Template. This is not correct. You need to use 1 file only and that is the template it will use to bring the data in. 

 

If these are .txt files, I would set up the input configuration like below. You might have to use a different code page depending on the languages used.  

Snag_3e85ee30.png

 

jdminton
12 - Quasar

@Yuvaraj85 Did you get this working?

Yuvaraj85
7 - Meteor

No. The text file contains LF need to be used for this

jdminton
12 - Quasar

Maybe I can make this more clear for you.

  1. Click on the dynamic input tool.
  2. Click the "Edit" button for the input data source template
  3. Select one of the LF files (this is just a template, all files will be brought in)
  4. Set the configuration for this file

Once you do those steps, it should work. See image below for visual

Snag_e58ebd2.png

 

 

Yuvaraj85
7 - Meteor

Thanks for your input. But it is not working if the text file is having data

Yuvaraj85
7 - Meteor

Thanks for your input. But it is not working if the text file is having data. If the txt is blank tab need to be added with the header provided in the layout. 

jdminton
12 - Quasar

Can you share what you are referring to? Nothing in the workflow should stop files with data. Can you share the updated workflow?

 

Can you show me an image of what you are wanting for "If the txt is blank tab need to be added with the header provided in the layout."? I'm not really sure what you want for that piece since previously:


@Yuvaraj85 wrote:

If the text is not having any data then that text file need to be skipped and rest of the text files need to be parsed. Please help me on this


 

Yuvaraj85
7 - Meteor

The version am having is not having the option "Action on skipping item" . I think this is the issue

Labels