topic Re: Data Format : CSV in QlikView

Data Format : CSV

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

Good day everyone, I need tips on how I can manipulate data from CSV file. Please see the attached file for details.

I can load the file into qlikview data editor but how can I separate the key data fields so that that will stand alone or appear like this:

room

start date

end date

not id/room/ start date/ end date

Thanks

Re: Data Format : CSV

Thu, 23 Jun 2016 12:21:47 GMT

Do you have a QVW to provide with?

Re: Data Format : CSV

avinashelite — Thu, 23 Jun 2016 12:24:58 GMT

Go to Edit Script> Table Files>choose the file> select CSV > chose the delimiter > if its not in the list >select the custom and the choose the delimiter as | pipe and then click on finish

Re: Data Format : CSV

MK_QSL — Thu, 23 Jun 2016 12:31:05 GMT

TableName:

LOAD id,

room,

[start date],

[end date],

[request id]

FROM

[..\Downloads\Booking.txt]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

Re: Data Format : CSV

akpofureenughwu — Thu, 23 Jun 2016 12:38:36 GMT

Yeah, Try this

Re: Data Format : CSV

Peter_Cammaert — Thu, 23 Jun 2016 13:07:52 GMT

Or even shorter:

TableName:

LOAD *

FROM [.\Booking.txt] (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

Best,

Peter

Re: Data Format : CSV

akpofureenughwu — Thu, 23 Jun 2016 13:11:19 GMT

Thanks Everyone..