Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
Creator II
Creator II

How to filter multiple columns in single QVD.

Hi Friends,

I have a table(Test) contains 6 columns

                                                                                                                                                                                                                                                                       

IDNAMEOWNEROWNER_AOWNER_BCITY
1RRRHCLCustomer_TCSothersHYD
2AAACustomer_HCLTCSHCLBANGALORE
3CCCTCSothersCustomer_TCSMUMBAI
4DDDCustomer_TCSCustomer_HCLCustomer_TCSHYD
5RRRothersHCLTCSBANGALORE
6AAACustomer_HCLCustomer_TCSothersMUMBAI
7CCCCustomer_HCLTCSHCLHYD
8DDDHCLothersCustomer_TCSBANGALORE
9RRRTCSCustomer_HCLCustomer_TCSMUMBAI
10DDDCustomer_TCSHCLTCSPUNE

AND HERE THE PROBLEM IS I WANT TO APPLY CONDITION IN TWO WAYS.

1) i want to display HLC AND Customer_HCL data in OWNER.OWNER_A AND OWNER_B

2) I dont want to display "others" in 3 columns(OWNER.OWNER_A AND OWNER_B).

pls help me how to apply.

3 Replies
yduval75
Partner - Creator III
Partner - Creator III

LOAD

  ID,

  NAME,

  OWNER,

  OWNER_A,

  OWNER_B,

  CITY

From table_test

where

   match(OWNER_A,  'HCL',  'Customer_HCL', 'others') > 0

   or  match(OWNER_B,  'HCL',  'Customer_HCL', 'others') > 0

  or  match(OWNER,  'others') > 0

;

its_anandrjs
Champion III
Champion III

Hi,

Try this for only HCL, Customer_HCL data

Tab1:

LOAD

    ID, NAME, OWNER, OWNER_A, OWNER_B, CITY

From Location

Where

Match(OWNER,'HCL','Customer_TCS')

or Match(OWNER_A,'HCL','Customer_TCS')

or Match(OWNER_B,'HCL','Customer_TCS');   

                   

Regards

Anand

fsimoes81
Partner - Contributor III
Partner - Contributor III

The Match function and your family, mixmatch and wildmatch are very functional.