This content has been marked as final. Show 2 replies
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 [C:\Users\jvn\AppData\Desktop\TaskLog.txt] (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