This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 72%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
get the inserted data in dataflow in ADF along with primary key after sink transformation so that I can use that primary key as foreign key to insert in to another table
Welcome to Microsoft Q&A platform and thanks for posting your question here.
I tried to understand your query but it's not quite clear, do you want to identify primary key from a source database and make it as a foreign key in sink database? Please elaborate a bit more on your ask.
Thankyou in advance.
I have excel with x1,x2,x3,x4,x5,x6 as fields. I want to vertically split the data i.e x1,x2,x3 has to load in to one table and get the primary key and use it as foreign key for other vertically split data so that I can have relationship
Did you get a chance to look at the previous response? Let me know if there is any further query. Thankyou
You can use select transformation in mapping dataflow to vertically split the columns . Create two branches from the source transformation and add two select transformation to split the columns vertically and add two sinks as well.