Page 1 of 1
use Data Transformation in Master-Details scenario
Posted: Sat Aug 22, 2020 8:07 am
by CWS116
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
Re: use Data Transformation in Master-Details scenario
Posted: Mon Aug 24, 2020 1:23 pm
by CWS116
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!
Re: use Data Transformation in Master-Details scenario
Posted: Wed Aug 26, 2020 8:24 am
by Lech Kulikowski
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.