look up

[satya99]

Hi,

Lookup data (Hashed File)

123456@10@b
123456@00@c

Source data ( Hashed file)

123456@00@c

I need to delete both the records from hash file if the first 6 positions are same.

Any advice.

Thanks in advance

[gateleys]

Hi,

Lookup data (Hashed File)

123456@10@b
123456@00@c

Source data ( Hashed file)

123456@00@c

I need to delete both the records from hash file if the first 6 positions are same.

Any advice.

Thanks in advance

Hello HELLO (God!! I feel stupid),
Delete both records from WHICH hashed file? Your source and lookup are both hashed files. Can you be a little more clear on your question?

[satya99]

From lookup.

Hi,

Lookup data (Hashed File)

123456@10@b
123456@00@c

Source data ( Hashed file)

123456@00@c

I need to delete both the records from hash file if the first 6 positions are same.

Any advice.

Thanks in advance

Hello HELLO (God!! I feel stupid),
Delete both records from WHICH hashed file? Your source and lookup are both hashed files. Can you be a little more clear on your question?

[ray.wurlod]

Code: Select all

                  HashedFile    UniVerse
                  (lookup)     (user-SQL)
                     :           ^
                     :           |
                     V           |
HashedFile   --->  TransformerStage  --->  (any)
 (source)

User-defined SQL in the UniVerse stage can effect the deletions you require.

[muruganr117]

Hi,

I am just giving my suggestion,
u can restrict the matching records using constraint and write rest unmatch records to work file and then write to the same hash file, clear before writing

regards
Murugan

Hi,

Lookup data (Hashed File)

123456@10@b
123456@00@c

Source data ( Hashed file)

123456@00@c

I need to delete both the records from hash file if the first 6 positions are same.

Any advice.

Thanks in advance

Hello HELLO (God!! I feel stupid),
Delete both records from WHICH hashed file? Your source and lookup are both hashed files. Can you be a little more clear on your question?