This content has been marked as final.
Show 2 replies
-
Re: Double Join to Same Table
Rohit Kumar Sep 24, 2016 4:15 AM (in response to Aravind Sasidharan)Hi Arvind,
I have created a sample application on your data , please have a look once and let me know what is your use case ,If you tell me what you want in Excel sheet so I can reflect it here on Sense.
-
Sample.qvf 192.0 K
-
Re: Double Join to Same Table
Aravind Sasidharan Sep 26, 2016 6:01 PM (in response to Rohit Kumar)Thanks Rohit.
I am trying to build a straight table in the form
Same Ticker Match
TICKER Buy Client Sell Client Buy Quantity Sell Quantity Sector Diff Ticker Match
Buy Ticker Sell Ticker Buy Client Sell Client Buy Quantity Sell Quantity Buy Sector Sell Sector
then need to have a single filter for either legs of the match. For example, choosing CLIENT_1 should filter the table and show all records where CLIENT_1 appears on either side of the match essentially the answer to the question give me all the matches involving CLIENT_1.
-