My query is somewat different. I have created a jdbc data set in which I have written my query. Now I am having a table where I am using data from this jdbc data set to populate the table.
Do I need to make a new scripted data set? If yes how do I get the query result in this data set for manipulation?
Scenario:(This is what I am getting as query result) (All the 3 rows are part of table only, I mean even total is also a part of result set, it has not been computed separately by adding the data of first two rows)
Desired:(This is what I want after manipulation)
Thanks in advance