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