Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Ok Sir. Thank You. It's working.
It's working.Thank You Sir
Please select Correct Answer and Close the thread.
Please select Correct Answer and Close the thread.