topic Re: How do I upload a TSV to Qlikview? in QlikView

How do I upload a TSV to Qlikview?

Thu, 24 Dec 2015 07:17:07 GMT

Hi All,

I have a large TSV file (1+GB) to be uploaded to Qlikview.

Now, opening this and converting to csv manually in excel is not possible due to the excel row limitations.

Please advice on how to get this done.

Thanks,

Shyam

Re: How do I upload a TSV to Qlikview?

MK_QSL — Thu, 24 Dec 2015 07:50:11 GMT

Have you tried loading TSV files directly to qlikview script same as CSV file?

Re: How do I upload a TSV to Qlikview?

Anonymous — Thu, 24 Dec 2015 07:53:23 GMT

check this:

Fetching Data from Tsv file merging data from one column to other

Re: How do I upload a TSV to Qlikview?

shaileshyerram — Thu, 24 Dec 2015 07:58:06 GMT

Hi Shyam,

Assuming TSV is nothing but a text file ith TAB as delimiter, I did a quick test by creating a .tsv file and loading it in Qlikview. I was able to load the tsv file usign the "Table Files" option in data load editor. Once the document is loaded, Qlikview has identified TAB as the delimiter by default.

So, as per my understanding we need not convert the tsv file to a csv file.

Note: If the tsv file is not visible in existing folder using "Table Files" option, make sure u select "All Files" in the file selection options.

Regards,

Shailesh Yerram

Qlikview Solutions Architect

Re: How do I upload a TSV to Qlikview?

Peter_Cammaert — Thu, 24 Dec 2015 08:01:08 GMT

In the Table file filter options dialog, select a different separator instead of a comma or semicolon. A Tab character is available too.

Re: How do I upload a TSV to Qlikview?

Thu, 24 Dec 2015 10:17:45 GMT

Thanks All!