Thanks, Simon. I was afraid the solution would be some work-around like this one. We use data that is protected by specific storage and connectivity requirements so I can't freely upload these files. Will have to decide whether the path of least resistance would be to convert the file type or add another workflow to upload the files as they are.
Thank you. Yes. I tried the following script:
LOAD * from filename.TSV (ansi, txt, delimiter is '\t', embedded labels);
But received the following error:
This statement only works with lib:// paths in this script mode
When I create a data connection to the filepath, the TSV file does not appear as an available file. I am stumped.
All, I've figured it out. Perhaps might be my lack of programming concepts knowledge. BUT, I did tag this post with 'tsv' so that other newbies won't have to go through the agony of searching for the solution. Below are the steps:
How to upload TSV file in Qlik Sense
- In the Data Load Editor, click on 'Create new connection' > Folder > follow the path to the folder where your file is located.
- Give the folder a name in the 'Name' box (in this example, we'll use 'foldername').
- Click 'Create'.
- When the connection is made, you will see that it appears under the Data Connections vertical toolbar in the right side of your screen with the name 'foldername'.
- In the load editor (main shell on the page), use the following script:
LOAD * from lib://foldername/filename.TSV (ansi, txt, delimiter is '\t', embedded labels);
Obviously, you can modify with this script with any valid arguments or fields. Hope this helps! Thank you to everyone who answered and helped!