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
In these cases, you have to think like the bot -- You want it skipped but the way the bot can "skip" it is by pulling it in and then excluding the blank lines from the data via a filtering tool or something else. I hope this helps!
f you give some example will be greatly appreciated
@Yuvaraj85
If you have multiple .txt files, input data by using wild card * to read all text data.
Once data is read, use filter tool to filter empty data. *Empty means "Null" or "Empty string". See attached yxzp.
Hi @Yuvaraj85 .I think that this is the issue you might be running into.
If so, switch to directory and dynamic input. You can then filter the directory to remove size 0 files:
The remainder of the text files can then flow through the process. You could also set up a run command tool to read in the files from the directory to move or delete size zero files before running your normal workflow. Either method should eliminate the blank text files. If you have headers but no data, use the method shared by @gawa
This is not working as we have separate layout file to delimit the text file.
Even this is also not working since I have separate layout to delimit it. Once I use filter in the basic filter when I tried to select column it show as no records
@Yuvaraj85 Can you please share your workflow so we can help? The directory method I shared will happen before any layouts as the layout will occur in the dynamic input, but I cannot understand what you are describing.
Here is the work flow, Could you please advise
I see that in the dynamic input you need to change the Action to "Change Entire File Path". Also, the false anchor for the filter would not have any data and would error. You can change to a Browse tool to see which files fail. See attached. Let me know if this is working or if you have any other issues.
It is working fine but the LF tab is not creating with the headers provided in the layout
@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.
@Yuvaraj85 Did you get this working?
No. The text file contains LF need to be used for this
Maybe I can make this more clear for you.
Once you do those steps, it should work. See image below for visual
Thanks for your input. But it is not working if the text file is having data
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.
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
The version am having is not having the option "Action on skipping item" . I think this is the issue
