PDI水壶--如何规范高级结构？

Question

我在一个MySQL数据库中有7列数据。Year1列属于Revenue1列。以下列具有相同的结构。我知道如何在SQL中处理这个问题，但在PDI中却不知道。有谁能描述一下是怎么做的吗？

mySQL表结构

+--------+-------+-------+-------+----------+----------+----------+
| Ticker | Year1 | Year2 | Year3 | Revenue1 | Revenue2 | Revenue3 |
+--------+-------+-------+-------+----------+----------+----------+
|        |       |       |       |          |          |          |
| ABC    |  2010 |  2011 |  2012 |   250000 |   500000 |  1000000 |
+--------+-------+-------+-------+----------+----------+----------+

所需的PDI标准化输出：

+------------+------+-----------+---------+
|     Ticker | Year | Keyfigure |  Value  |
+------------+------+-----------+---------+
|            |      |           |         |
|     ABC    | 2010 | Revenue   |  250000 |
|            |      |           |         |
|     ABC    | 2011 | Revenue   |  500000 |
|            |      |           |         |
|     ABC    | 2012 | Revenue   | 1000000 |
+------------+------+-----------+---------+

Answer 1

你有没有试过使用行反正规化？