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
- 12 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Name some data sources used in qlikview?
What are the two basic levels at which security attain in QlikView?
How are Hierarchy() and Hierachybelongsto() different from each other?
What can you do from a box plot wizard?
Tell three advantages of qlikview?
What is the use of the function intervalmatch?
What are the parameters required by a crosstable wizard to create a cross table?
What is the use of select statement?
What is the function of the Directory Service Connector?
What are the two ways to insert load statements into script editor?
Explain 3 tier architecture implementation while deploying qlikview application?
Explain the uses of charts?
QlikView 
