topic Re: Drop fields on run time in QlikView

Drop fields on run time

Anonymous — Thu, 07 Dec 2017 11:15:28 GMT

Hi All,

Please let me know how to implement drop field dynamically

Example :

Table 1:

Region Customer

A ABC

B BDE

Table2:

Region Customer

* ABC

B *

Drop field based on the Table 2 entry,

example:

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

Re: Drop fields on run time

Anil_Babu_Samineni — Thu, 07 Dec 2017 11:43:15 GMT

May be this?

Table1:

Load * Inline [

Region, Customer

A, ABC

B, BDE

];

Qualify *;

Table2:

Load * Inline [

Region ,Customer

* ,ABC

B ,*

];

Final:

NoConcatenate

If Table2.Region = '*' or Table2.Customer = '*' Then

Drop Field Table2.Region;

Else

Drop Field Table2.Customer;

Re: Drop fields on run time

big_dreams — Thu, 07 Dec 2017 12:35:31 GMT

Can you explain real scenario??

Difficult to understand.

Regards,

Re: Drop fields on run time

el_aprendiz111 — Thu, 07 Dec 2017 17:33:46 GMT

Hi,

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;