topic Re: Assist with script please in QlikView

Assist with script please

QFanatic — Wed, 17 Feb 2021 14:31:16 GMT

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.

Re: Assist with script please

haskia — Wed, 17 Feb 2021 20:49:06 GMT

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. 🙂

Re: Assist with script please

QFanatic — Thu, 18 Feb 2021 07:10:28 GMT

Brilliant thank you!