topic Fetching Data from Tsv file merging data from one column to other in QlikView

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

SunilChauhan — Thu, 11 Apr 2013 02:31:46 GMT

Hi All,

i am fetching Data from tsv file. using Tab delimeter

Load *

from path\filename.tsv

(txt,Unicode, delimeter is '\t',MSQ)

data loaded but it merging from one column to other.

could any one please suggest.

Thanks In advance.

Sunil

m_woolf — Thu, 11 Apr 2013 11:01:54 GMT

It sounds like the file is not tab delimited. Have you examined the file in a text editor (Notepad++)?

MarcoARaymundo — Thu, 11 Apr 2013 15:30:47 GMT

Hi!

place the file to see.

SunilChauhan — Sun, 21 Apr 2013 14:53:24 GMT

sorry its confidential data .

i can't share.

MarcoARaymundo — Mon, 22 Apr 2013 12:20:26 GMT

OK! but you can place a txt example file without a true data.

SunilChauhan — Mon, 22 Apr 2013 15:10:29 GMT

Thanks for your nice response. we have just converted file into xls.

issue resolved .