Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vchuprina
Not applicable

How separate data in column?

Hi All,

I new in QlikView.

Now I work with csv format file and have a problem.

I don't know how to separate data from one column (48 symbols) in different columns

Length of future columns:

SALES-DATE ( 8 )

UPC ( 15 )

STORE ( 4 )

SALES-UNIT ( 8 )

SALES-DOLLARS ( 13 )

Please help.

1 Solution

Accepted Solutions
colin_albert
Not applicable

Re: How separate data in column?

The file is a fixed width file not csv.  Select the file type Fixed Record and you can then specify the column widths by clicking the file preview.

fixed.JPG


4 Replies
agomes1971
Not applicable

Re: How separate data in column?

Hi,

LOAD @1:8,

     @9:22,

     @23:26,

     @27:35,

     @36:n

FROM

[..\data.csv]

(fix, codepage is 1252);

Regards

André Gomes

colin_albert
Not applicable

Re: How separate data in column?

The file is a fixed width file not csv.  Select the file type Fixed Record and you can then specify the column widths by clicking the file preview.

fixed.JPG


vchuprina
Not applicable

Re: How separate data in column?

Andre, thank you for the "fish".

vchuprina
Not applicable

Re: How separate data in column?

Colin, thank you for the fishing rod.)