Load Statement Question

[#1]

Hello,

I'd like to filter the field Desc_text during load. Data looks like this:


UserNr. CaseNr. Desc_Text Date user_Status
=============================================================
17 101 Text1 08.07.08 New
17 201 Text1 08.07.08 Known
17 301 Text2 22.08.08 Known
17 301 Text1 17.08.08 Known
17 301 Text3 22.08.08 Known


Outcome should look like:

UserNr. CaseNr. Desc_Text Date user_Status
=============================================================
17 101 Text1 08.07.08 New
17 301 Text2 22.08.08 Known
17 301 Text3 22.08.08 Known

Thank you.

Regards

[#2]

Hi John,

great. Exactly what I was looking for. Thank you very much.