topic How to delete commom records in QlikView

How to delete commom records

Vinod — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Table1 :

LOAD * INLINE [

Year, Value

2001, 100

2002, 200

2003, 300

2004, 400

2005, 500

2006, 600

2007, 700

2008, 800

2009, 900

2010, 500

];

Table2 :

LOAD * INLINE [

Year

2001

2010

2005

2006

2007

] ;

Above I have created two table and in that two tables i want to delete common Year from both the table and I want output like below mentioned table.

Year	Value
2002	200
2003	300
2004	400
2008	800
2009	900

Please anyone reply.

Regards,

Vinod

Re: How to delete commom records

sunny_talwar — Fri, 03 Aug 2018 14:27:30 GMT

May be this

Table2:

LOAD * INLINE [

Year

2001

2010

2005

2006

2007

];

//Table1:

LOAD * INLINE [

Year, Value

2001, 100

2002, 200

2003, 300

2004, 400

2005, 500

2006, 600

2007, 700

2008, 800

2009, 900

2010, 500

]

Where Not Exists(Year);

DROP Table Table2;

Re: How to delete commom records

Anil_Babu_Samineni — Fri, 03 Aug 2018 14:30:19 GMT

May be this?

Table2 :

LOAD * INLINE [

Year

2001

2010

2005

2006

2007

];

Table1 :

LOAD * INLINE [

Year, Value

2001, 100

2002, 200

2003, 300

2004, 400

2005, 500

2006, 600

2007, 700

2008, 800

2009, 900

2010, 500

] Where Not Exists(Year);

Drop Table Table2;

Re: How to delete commom records

Vinod — Sat, 04 Aug 2018 07:27:33 GMT

Ok Sir. Thank You. It's working.

Re: How to delete commom records

Vinod — Sat, 04 Aug 2018 07:28:51 GMT

It's working.Thank You Sir

Re: How to delete commom records

qlikviewwizard — Mon, 06 Aug 2018 03:45:49 GMT

Please select Correct Answer and Close the thread.

Re: How to delete commom records

nasirsaikh — Fri, 19 Oct 2018 07:08:24 GMT

Please select Correct Answer and Close the thread.

Re: How to delete commom records