Data Format : CSV

[akpofureenughwu]

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:

id

room

start date

end date

not id/room/ start date/ end date

Thanks

[#2]

Do you have a QVW to provide with?

[avinashelite]

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

[MK_QSL]

TableName:

LOAD id,

     room,

     [start date],

     [end date],

     [request id]

FROM

[..\Downloads\Booking.txt]

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

[akpofureenughwu]

Yeah, Try this

[Peter_Cammaert · Accepted solution]

Or even shorter:

TableName:

LOAD *

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

Best,

Peter

[akpofureenughwu]

Thanks Everyone..