Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

separator check

Hello,

I want to do a sperator check in an incoming CSV file, for example if I have a separator other than";" I reject the file, also for encoding "utf_8" and returns to the line '\n'  , otherwise I continue my processing  

big thanks

 

Labels (3)
1 Reply
Anonymous
Not applicable
Author

Logically there is no need to do this.

 

If you use your tFileInputDelimited component and configure it to use a ";" as the separator, you can throw the file away (or reject it) if your columns are missing data. If you have 5 columns of data and there are no ";" in there, it will mean that only your first column will have data. Columns 2, 3,4 and 5 will not be consistently populated. 

 

Adding a checking stage before attempting to process it will probably be less efficient than checking it while you consume it.