The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.
How to use one data set output to create another data set dynamically
I have one data set as below 
final result should be like below. each deal should get the accumulated Debit and credit based on it's parent deal id.
0
Answers
You can achieve this by doing all your calculations in a stored procedure and access that stored procedure in a Data Set of type "SQl Stored Procedure Query"