Fixed File conditional delete issue

gayatri7 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am loading the data from fixed text file and below is the code, which is working fine.

LOAD [@1:2] as [Codigo Banco],

[@11:25] as [Policy Number],

[@44:52] as [Monto de cobro],

[@55:62] as [Fecha de envio],

[@63:70] as [Fecha de cargo]

FROM

[..\Raw Data1\CBC_01042017.txt]

(fix, codepage is 1252);

I have a row at the end in the file which indicates the total value of the data. I wanted to delete that particular row while loading the source data. I have used enable transformation step and below code has been generated

(txt, codepage is 1252, no labels, delimiter is ' ', msq, no eof, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'T')))

));'

Since I am using the Fixed file I have removed the txt with fix (as I was using earlier), now my code looks like below and it is throwing error.

LOAD [@1:2] as [Codigo Banco],

[@11:25] as [Policy Number],

[@44:52] as [Monto de cobro],

[@55:62] as [Fecha de envio],

[@63:70] as [Fecha de cargo]

FROM

[..\Raw Data1\CBC_01042017.txt]

(fix, codepage is 1252, no labels, delimiter is ' ', msq, no eof, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'T')))

));

attaching the sample raw data

Re: Fixed File conditional delete issue

marcus_sommer — Tue, 11 Jul 2017 10:18:53 GMT

I think I would try something like this:

LOAD * where not wildmatch([Policy Number], '*T*');

LOAD [@1:2] as [Codigo Banco],

[@11:25] as [Policy Number],

[@44:52] as [Monto de cobro],

[@55:62] as [Fecha de envio],

[@63:70] as [Fecha de cargo]

FROM

[..\Raw Data1\CBC_01042017.txt]

(fix, codepage is 1252);

- Marcus

Re: Fixed File conditional delete issue

gayatri7 — Tue, 11 Jul 2017 10:33:24 GMT

Hey Marcus,

Thanks for your quick reply. It works for me!!!!!!

topic Re: Fixed File conditional delete issue in QlikView

Fixed File conditional delete issue

Re: Fixed File conditional delete issue

Re: Fixed File conditional delete issue