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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comments in tFileInputDelimited

Hi,
Is it possible to include comment lines in a tFileInputDelimited ?
I actually use it to load a tContextLoad and I want to put some comments on the values given.
Thanks.
Labels (2)
6 Replies
Anonymous
Not applicable
Author

I don't think it's very easy with comment line.
My advice is to use a comment column
Your file would be
key;value;comment
key1;value1;comment1
You can read only key and value columns with your tFileInputDelimited before your tContextLoad
Regards,
Anonymous
Not applicable
Author

What would you like to do? Just ignore the comments? How do you know its a comment (line starting with "#" for example)?
In this case you may use a filter.
Please give us some more information to help you.
Bye
Volker
Anonymous
Not applicable
Author

Exactly Volker, I just want to describe the key and value of the tFileInputDelimited, the comments should be ignored.
Anonymous
Not applicable
Author

Can you please give us an example of your input data.
Anonymous
Not applicable
Author

Here is a sample of the csv file, I used a comment column and it is ignored by the tContextLoad:
mysql_host;0.0.0.0;MySQL IP adress
mysql_port;3306;MySQL Port
mysql_db;talend;MySQL database name
mysql_user;talend;MySQL user
mysql_pass;talend;MySQL Password
...
It works perfectly now. Thanks.
Anonymous
Not applicable
Author

You are welcome.