Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
It works! Thanks!!!