ROW COLUMN SWAPPING BETWEEN 2 TABLES IN BODS

[former_member590297]

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 ???

[former_member187605 · Accepted solution]

You could use a file instead of a table 🙂

• A > File
• B > A
• File > B