Discussion Board for collaboration on QlikView Scripting.
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:
How do I properly do that in the load script?
if([O-ID] = [O-ID2], DROP FIELD [C-ID])
can you provide an extended example and the expected result?
expected result (from what I understand)
load * inline [
if(Exists([O-ID2], [O-ID]), null(), [C-ID]) as [C-ID],
C-ID, L-ID, O-ID
2, Y, 222