topic Re: Task? in QlikView

Task?

Sat, 18 Oct 2014 15:32:07 GMT

Hi,

Scenario 2:

Suppose field 2 should contain numeric values

Row1   12102014
Row2   12102014
Row3   adxsdfe
Row4   12102014
.         .
.
.
.
Rown

During load I want to replace the text with 0's and then load into QVD. Also I want to capture the row with erroneous data into a separate QVD file.

Here text need to store as one qvd   and other qvd need to replace text with 0 and store as a qvd

Re: Task?

antoniotiman — Sat, 18 Oct 2014 15:47:28 GMT

HI,

Table:

Load *

from Table;

Table_OK:

Noconcatenate

Load

Row,

If(alt(Date#(Date,'DDMMYYYY'),0) > 0, Date,0) as Date

Resident Table;

Store Table_OK into Table_OK.qvd (qvd);

Table_NOK:

NoConcatenate

Load *

Resident Table

Where alt(Date#(Date,'DDMMYYYY'),0) = 0;

Store Table_NOK into Table_NOK.qvd (qvd);

Drop Table Table;

Drop Table Table_NOK;