Skip to Content
0
Aug 23, 2018 at 03:02 PM

ROW COLUMN SWAPPING BETWEEN 2 TABLES IN BODS

120 Views

I have two tables A and B, with the same column structure X, Y. And in table A, I have two rows, x1 y1 and x2 y2. and in table B I have two rows x3 y3 and x4 y4. Now I want to swap the data of table A with table B without using any other table. How do i do it using BODS Transformations.. ie, before swap (A have (x1 y1, x2 y2) and B has (x3 y3, x4 y4). and after swap (running the job), table A should have (x3 y3, x4 y4) and table B should have (x1 y1, x2 y2)... How do i achieve this using BODS Dataflow, what are the transformations i need to use and in what flow ???