Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pelle90
Contributor II
Contributor II

Identify and delete None Matching Data (associations)

Hi.

I have two tables, one with sales orders and one with product-information.

They are connected through a Product ID. However only some of the product IDs are involved in sale transactions. This means that there are some product IDS which exists in the Product-table but not in the sales table. I want to delete the products (entire row) for the products that haven´t been involved in a sale transaction.

 

So ending result will be a modified product table with only products that have at least one sales transaction. (and sales table will stay the same).

 

Any suggestions? Thanks in advance!

Labels (2)
1 Solution

Accepted Solutions
HirisH_V7
Master
Master

Some thing like this, using sample tables...

 

Sales:
LOAD * INLINE [
    Sales, Product_ID
    33, 1
    22, 2
];

Product:
LOAD * INLINE [
    Product_ID, Product_Name
    1, A
    2, B
    3, C
]where Exists(Product_ID,Product_ID);

//Or use inner join like..

Sales:
LOAD * INLINE [
    Sales, Product_ID
    33, 1
    22, 2
];

Inner Join


Product:
LOAD * INLINE [
    Product_ID, Product_Name
    1, A
    2, B
    3, C
];

 

You can use left join or keep with sales table as well. Follow, where exists for better performance.

HTH,

Hirish 

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

2 Replies
HirisH_V7
Master
Master

Some thing like this, using sample tables...

 

Sales:
LOAD * INLINE [
    Sales, Product_ID
    33, 1
    22, 2
];

Product:
LOAD * INLINE [
    Product_ID, Product_Name
    1, A
    2, B
    3, C
]where Exists(Product_ID,Product_ID);

//Or use inner join like..

Sales:
LOAD * INLINE [
    Sales, Product_ID
    33, 1
    22, 2
];

Inner Join


Product:
LOAD * INLINE [
    Product_ID, Product_Name
    1, A
    2, B
    3, C
];

 

You can use left join or keep with sales table as well. Follow, where exists for better performance.

HTH,

Hirish 

HirisH
“Aspire to Inspire before we Expire!”

View solution in original post

pelle90
Contributor II
Contributor II

Thank you!