Lookup not matching

[satya99]

I have a source Hashed file

ex:

No1(key) No2 no3

100~8~T 205
100~9~T 305 405

I need to perform a look up against the same hashed file.

So i created a new hashed file from the source and split the key into


Noa(Key) Nob(Key) Noc(Key) No2 no3

100 8 T 205
100 9 T 305 405


Now i am performing a lookup.

when ever there is a match on 100~8~T then i need to have the same value 205 in 100~9~T(no3) so that my output should look like

ex:

No1(key) No2 no3

100~8~T 205
100~9~T 305 205(Changed from 405 to 205)

Any advice

Thanks in advance

** Note: Subject changed to be more descriptive - Content Editor**

[ray.wurlod]

Do the lookup. If it is not found, make no change. If it is found, make the change.

[satya99]

When i find a match on 100~8~T then i need to use value in no2 column i.e 205 and drop it in no3 column of 100~9~t(cross reference)


No1(key) No2 no3

100~8~T 205
100~9~T 305 405

Noa(Key) Nob(Key) Noc(Key) No2 no3

100 8 T 205
100 9 T 305 405

o/p

No1(key) No2 no3

100~8~T 205
100~9~T 305 205(Changed from 405 to 205)

[ray.wurlod]

Yeah. I understood that and provided the solution.

Code: Select all

If RefLink.NOTFOUND Then InputLink.TheValue Else RefLink.TheValue

[satya99]

Here is the output

No1(key) No2 no3

100~8~T 205 205(changed from '' to 205 aswell) this should not happen
100~9~T 305 205(Changed from 405 to 205)

[ray.wurlod]

Post your actual derivation expressions.

[satya99]

IF lkp.NOTFOUND THEN scr.no ELSE lkp.no

I created the look up from the source, am i supposed to do that?

[ray.wurlod]

In your original question you stated that you had already created the hashed file so I took it as given.

[satya99]

Well i created hashed file from source and doing a look up, but i am not getting the expected result.

[chulett]

Then it seems you're not populating your keys properly for the lookup. And that can include something as simple as trimming trailing spaces in your incoming values.

[kandyshandy]

Satya, Can you explain your requirements with more than 2 rows with different values for the key?

[chulett]

Yes, can you please provide examples of what you get from the lookup (the unexpected result) and examples of what your "expected result" would be in that case. Also, "View Data" on your hashed file and ensure that it looks like you've built it properly - as expected. Click inside the key values in the browser to ensure there's nothing tripping you up like trailing spaces there rather than in your incoming data.

[satya99]

Source is hashed file.

ex:

No1(key) No2 no3

combination 1

100~8~T 205
100~9~T 305 405

combination 2

200~7~T 101
200~9~T 201 202

This is how the output should loook like:

combination 1

100~8~T 205
100~9~T 305 205 (cross ref)


combination 2

200~7~T 101
200~9~T 201 101 (cross ref)

[kandyshandy]

Satya, To be more precise...

Your source hash file (1 file) contains data like this

100~8~T 205
100~9~T 305 405
200~7~T 101
200~9~T 201 202

And you want output like shown below in one target file?

100~8~T 205
100~9~T 305 205
200~7~T 101
200~9~T 201 101

So you are using the first part (100 or 200) to differentiate the combination?

[satya99]

yes,