topic Re: Drop Field if Match? in QlikView

Drop Field if Match?

Fri, 05 Jun 2015 20:12:41 GMT

Hi,

I have two tables and the Key is C-ID. I haven't loaded in O-ID in table 1 yet but I want to make the connection between Table 1 and Table 2 with rows that have O-ID and drop the C-ID for those rows:

Table 1:

C-ID	L-ID	O-ID
1	X
2	Y	222
3	Z

Table 2:

C-ID	O-ID2
1	111
2	222

How do I properly do that in the load script?

if([O-ID] = [O-ID2], DROP FIELD [C-ID])

Thanks!

Jason

Re: Drop Field if Match?

MarcoWedel — Fri, 05 Jun 2015 20:29:44 GMT

‌can you provide an extended example and the expected result?

regards

Marco

Re: Drop Field if Match?

maxgro — Sat, 06 Jun 2015 17:43:26 GMT

expected result (from what I understand)

Table2:

load * inline [

C-ID, O-ID2

1, 111

2, 222

];

Table1:

load

if(Exists([O-ID2], [O-ID]), null(), [C-ID]) as [C-ID],

[L-ID],

[O-ID]

inline [

C-ID, L-ID, O-ID

1, X,

2, Y, 222

3, Z,

];