Task?

[#1]

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

[antoniotiman · Accepted solution]

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;