Discussion Board for collaboration related to QlikView App Development.
Please let me know how to implement drop field dynamically
Drop field based on the Table 2 entry,
first time it has to drop region field from Table 1 , bcoz * is entered in Table 2 Region Field
Second time it has to drop Customer field from Table 1 , bcoz * is entered in Table 2 Customer Field
Thanks in advance
May be this?
Load * Inline [
If Table2.Region = '*' or Table2.Customer = '*' Then
Drop Field Table2.Region;
Drop Field Table2.Customer;
Can you explain real scenario??
Difficult to understand.
Table1: Load * Inline [ Region, Customer A, ABC B, BDE ] ; Outer Join Table2: Load * Inline [ Region ,Customer *,ABC B,* ] ; Mapping Reg: LOAD Region,Customer Resident Table1 ; Mapping Cus: LOAD Customer,Region Resident Table1 ; SUMARY: LOAD *, ApplyMap('Cus',Customer,Null()) AS Region1, ApplyMap('Reg',Region, Null()) AS Customer1 Resident Table1 ; DROP Table Table1;