tough task?

[#1]

Hi experts,

Date Format should be DD/MM/YYYY. Suppose there are n rows where row 2 and row 4 have different date formats


Row1   12/10/2014
Row2   12-10-2014
Row3   12/10/2014
Row4   12-10-2014
.         .
.
.
.
Rown    DD/MM/YYYY

During load I want to eliminate the rows with erroneous date format and convert into qvd. at the same time i want all the erroneous rows to be stored into a QVD called Error.Qvd.

how to store non erroneous dates in one qvd and at same time how to create qvd for erroneous data?

is it possible to create 2 qvds  at a time ? 

[antoniotiman]

Hi,

Try

Load *

Where alt(Date#(Date,'DD/MM/YYYY'),0) > 0;

Load *

from Table;

You load only correct date.

Regards,

Antonio

[#3]

for wrong date i need to create?

[MarcoWedel · Accepted solution]

Hi,

one solution:

QVD correct dates

QVD incorrect dates

tabSource:
LOAD * INLINE [
    Row, Date
    Row1, 12/10/2014
    Row2, 12-10-2014
    Row3, 12/10/2014
    Row4, 12-10-2014
];

NoConcatenate

tabCorrectDates:
LOAD *
Resident tabSource
Where IsNum(Date);

NoConcatenate

tabIncorrectDates:
LOAD *
Resident tabSource
Where not IsNum(Date);

DROP Table tabSource;

STORE tabCorrectDates into tabCorrectDates.qvd (qvd);

STORE tabIncorrectDates into tabIncorrectDates.qvd (qvd);

hope this helps

regarsd

Marco

[antoniotiman]

For wrong date use

Where alt(..............) = 0;

[veidlburkhard]

Hi manojqlik,

this Where clause gives you the incorrect data formats:

Load *

Where alt(Date#(Date,'DD/MM/YYYY'),0) = 0;

Load *

from Table;

(see QV Help, 'Conditional Functions', 'Alt')

Hope this helps

Burkhard

[#7]

Hi Manoj.

Does this attachment help answer your question?

Regards

[#8]

Hello manoj ,

Try like this