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
- 1 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 |
Define apply map?
What is preceding load?
How are Hierarchy() and Hierachybelongsto() different from each other?
What additional date fields can you add using a Master Calendar?
How can you create a bookmark in QlikView?
Name some companies using QlikView?
What is meant by technical approaches of bi? Name them.
What is mapping load & apply map ()?
What do you understand by Rangesum() function? How is it different from the Sum() function?
What is synthetic key, is it good or bad to have?
How is the scope of aggregation defined?
Define noconcatenation?
QlikView 
