Interested to Buy Any Domain ? << Click Here >> for more details...
What are the three options available under the rotate table functionality for data transformation?
- 1 Answers
- 2 Views
- I also Faced
- E-Mail Answers
Answer Posted / Prashank Srivastava
"Load * Inline [
Table1: (
Col1 as NewCol1,
Col2 as NewCol2,
Col3 as NewCol3
);
LOAD * INLINE [
RotateTable: (
Col1 as OldCol1,
Col2 as OldCol2,
Col3 as OldCol3
)
];
CREATE TABLE Table2 AS SELECT NewCol1, OldCol1, NewCol2, OldCol2, NewCol3, OldCol3 FROM Table1 ROTATE;
LOAD * INLINE [
RotateTable: (
Col3 as OldCol3,
Col1 as OldCol1,
Col2 as OldCol2
)
];
CREATE TABLE Table3 AS SELECT NewCol1, OldCol1, NewCol2, OldCol2, NewCol3, OldCol3 FROM Table1 ROTATE REVERSE;
"]
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
