Hello,
Is there any way to use a Data Transformation in Master-Details scenario?
I tried it but when I add relationship to the Detail Data Bands, they don't show anything
use Data Transformation in Master-Details scenario
Re: use Data Transformation in Master-Details scenario
I have a table include a column for Transaction Ids and other columns for details and each transaction have multi row in table. like this:
| Transaction_ID | Product_ID |
|1 | 10 |
|1 | 11 |
|1 | 12 |
|2 | 10 |
|2 | 11 |
I use Master-Details scenario so I have to use another store procedure for retrive same Transaction_IDs for master band because we can't add relationship between Transaction_IDs in same table. I guess, I can use Data Transformation instead of that store procedure for create other table.
If this can be done please help us.
Thanks!
| Transaction_ID | Product_ID |
|1 | 10 |
|1 | 11 |
|1 | 12 |
|2 | 10 |
|2 | 11 |
I use Master-Details scenario so I have to use another store procedure for retrive same Transaction_IDs for master band because we can't add relationship between Transaction_IDs in same table. I guess, I can use Data Transformation instead of that store procedure for create other table.
If this can be done please help us.
Thanks!
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: use Data Transformation in Master-Details scenario
Hello,
Unfortunately, at the current moment, the master-detail construction is not supported for Data Transformation.
You can use the "Data from other data source" for that task.
Thank you.
Unfortunately, at the current moment, the master-detail construction is not supported for Data Transformation.
You can use the "Data from other data source" for that task.
Thank you.