Process Help

SELDEL - selectively delete named fields during a file copy

 

Process Name

Menu Path

Link to Command Table

SELDEL

ata ribbon | Data Tools | Tables | Delete Fields

Click here

 

Introduction

Selectively deletes named fields from the input file during a copy to the output file.

How to use

The fields to be deleted are specified as *F1 to *Fn. Any number of required fields may be deleted, but only one is compulsory.

If retrieval criteria are specified they will be ignored if they are on the deleted fields.

If the optional parameter @KEEPALL is zero (default) the output file will only contain one entry for each combination of output field values, provided that the input file is first sorted on these fields. If the input file is not sorted, then the output file will contain one entry for each combination of output field values which occur together in the input file.

The process works by checking the selected field values against the values just written to the output file. If they are identical, the current record is skipped.

Files, Fields and Parameters

Input Files

Name

Description

I/O Status

Required

Type

IN

Input file.

Input

Yes

Table

FIELDLST

File to supply selected fields.

Input

No

Undefined

Output Files

Name

I/O Status

Required

Type

Description

OUT

Output

Yes

Table

Output file with deleted fields.

Fields

Name

Description

Source

Required

Type

Default

F1

Deleted field 1.

IN

No

Any

Undefined

F2

Optional second deleted field.

IN

No

Any

Undefined

F3

Optional third deleted field.

IN

No

Any

Undefined

F4

Optional fourth deleted field.

IN

No

Any

Undefined

F5

Optional fifth deleted field.

IN

No

Any

Undefined

F6

Optional sixth deleted field.

IN

No

Any

Undefined

F7

Optional seventh deleted field.

IN

No

Any

Undefined

F8

Optional eighth deleted field.

IN

No

Any

Undefined

F9

Optional ninth deleted field.

IN

No

Any

Undefined

F10

Optional tenth deleted field.

IN

No

Any

Undefined

F11

Optional eleventh deleted field.

IN

No

Any

Undefined

F12

Optional twelfth deleted field.

IN

No

Any

Undefined

F13

Optional thirteenth deleted field.

IN

No

Any

Undefined

F14

Optional fourteenth deleted field.

IN

No

Any

Undefined

F15

Optional fifteenth deleted field.

IN

No

Any

Undefined

F16

Optional sixteenth deleted field.

IN

No

Any

Undefined

F17

Optional seventeenth deleted field.

IN

No

Any

Undefined

F18

Optional eighteenth deleted field.

IN

No

Any

Undefined

F19

Optional nineteenth deleted field.

IN

No

Any

Undefined

F20

Optional twentieth deleted field.

IN

No

Any

Undefined

F21

Optional twenty first deleted field.

IN

No

Any

Undefined

F22

Optional twenty second deleted field.

IN

No

Any

Undefined

F23

Optional twenty third deleted field.

IN

No

Any

Undefined

F24

Optional twenty fourth deleted field.

IN

No

Any

Undefined

F25

Optional twenty fifth deleted field.

IN

No

Any

Undefined

FIELDNAM

Field in FIELDLST to identify selected fields.

FIELDLST

No

Character

Undefined

Parameters

Name

Description

Required

Default

Range

Values

KEEPALL

Used to keep or delete records with duplicate successive key field values

Option

Description

(0)

Do not copy successive duplicate records.

1

Copy all records to Output File, even if adjacent records have identical Key Field values.
 		 No 0 0,1 0,1

KEYTOL

KEYTOL is the tolerance value used to test whether numeric key values are equal. It must be greater than or equal to zero. It replaces the previous heuristic comparison method.

If KEYTOL is set to a negative value then zero is used.

In a macro KEYTOL can be set to absent using -. "@KEYTOL=-" This will revert to legacy behaviour of a tolerance of zero being used.

No

0.00001

0,+

Undefined

Notes

No additional notes.

Example

!SELDEL     &IN(ASSAYS),&OUT(CUAU),*F1(BHID),*F2(FROM),*F3(TO)

 Error and Warning Messages

Message

Description

Solution