Assist with script please

[QFanatic]

hi,

Please find attached.

so I am working with a very large table called Resources.

I want to join the table below it, based on link field Uiid_or_Device..BUT only where Res_Itm_Tp_Cd = '1'  (in Resources)

if possible, I dont want to do a resident load from Resources again, since it will grow very big.

Please may you assist me with script to achieve this? Thank you.

[haskia · Accepted solution]

Hi QFanatic,

This could work...

You can simply add another field in your previous table to make sure the join is only applied when the condition is met.  Let us know if that helped.  🙂 

[QFanatic]

Brilliant thank you!