BUG (?): Column Fill in text file import does not work

Thu, 23 Feb 2012 11:43:47 GMT

Hi,

Using File wizard.Transformation I’m trying to add an extra column which is filled value of adjacent column if the later contains ‘ClusterID’.

This gives desired result on the preview:

The following code is generated

LOAD @1, 
     @2, 
     @3, 
     @4, 
     @5
FROM
(txt, utf8, no labels, delimiter is '\t', msq, filters(
ColXtr(3, RowCnd(CellValue, 3, StrCnd(contain, 'ClusterID')), 0), 
Replace(4, top, StrCnd(null))
));

(note two extra columns were added)

If i try reload the script, column 4 and 5 are empty!

Now, I've copy the content of the file to excel and using the exact same procedure i came up with the following code:

LOAD @1, 
     @2, 
     @3, 
     @4
FROM
C:\Users\jvn\AppData\Desktop\TaskLog.xlsx
(ooxml, no labels, table is Sheet1, filters(
ColXtr(3, RowCnd(CellValue, 3, StrCnd(contain, 'ClusterID')), 0), 
Replace(4, top, StrCnd(null))
));

this, DOES give up the desired results

What am i doing wrong?

Attached zip with source files and .qvw

BUG (?): Column Fill in text file import does not work

Thu, 23 Feb 2012 12:28:09 GMT

Hi,

try this

LOAD @1 AS 1,

@2 AS 2,

@3 AS 3,

@4 AS 4

FROM

TaskLog.txt

(txt, utf8, no labels, delimiter is '\t', msq, filters(

ColXtr(3, RowCnd(CellValue, 3, StrCnd(contain, 'cluster')), 4),

Replace(4, top, StrCnd(null))

));

Kind regards

BUG (?): Column Fill in text file import does not work

Thu, 23 Feb 2012 12:32:05 GMT

It works! Thanks!!!

topic BUG (?): Column Fill in text file import does not work in QlikView

BUG (?): Column Fill in text file import does not work

BUG (?): Column Fill in text file import does not work

BUG (?): Column Fill in text file import does not work