Checking a source file for missing/ wrong field names

Wed, 29 Oct 2014 05:26:37 GMT

Re: Checking a source file for missing/ wrong field names

jagan — Wed, 29 Oct 2014 06:09:59 GMT

Hi,

Try like this

Hi,

Try this sample script

Table:

LOAD

INLINE [

A,B,C

1,2,3];

QVDTable:

LOAD

INLINE [

A,B,D

1,2,4];

LET vFieldName = '';

LET vQVDTableFieldName = FieldName(3, 'Table');

For i = 1 TO NoOfFields('QVDTable')

LET vTableFieldName = FieldName($(i), 'Table');

LET vQVDTableFieldName = FieldName($(i), 'QVDTable');

IF vTableFieldName = vQVDTableFieldName THEN

//DO Nothing

ELSE

LET vFieldName = vFieldName & vQVDTableFieldName & ';';

ENDIF

NEXT i

Regards,

Jagan.