Question

我想把每种产品中的子产品(id)放在优先地位。

Product_id	Sub_product	Category
10101010	02020202	Superior
10101010	02020204	High-valued
0120202	0930303	High-valued
0120202	039303	VALUE
0303303	039302929	VALUE
0303303	0393342929	AddOn

预期结果如下:

Product_id	Sub_product	Category	Priority
10101010	02020202	Superior	1
10101010	02020204	High-valued	2
0120202	0930303	High-valued	1
0120202	039303	VALUE	2
0303303	039302929	VALUE	1
0303303	0393342929	AddOn	2

www.un.org/spanish/ecosoc 优先秩序:

Superior = 1
High-valued = 2
VALUE = 3
AddOn = 4

利用衍生栏,我可以实现以下产出。

Product_id	Sub_product	Category	Priority
10101010	02020202	Superior	1
10101010	02020204	High-valued	2
0120202	0930303	High-valued	2
0120202	039303	VALUE	3
0303303	039302929	VALUE	3
0303303	0393342929	AddOn	4

是否有可能从每件产品1个开始?

Answer 1

在编外栏目之后,您可使用窗口改造,将其分成<条码>产品_id栏,并适用于每个组的<条码>功能。以下是数据流的步骤。

Give the Product_id column name in the over section of window settings.

Give the Priority column that is computed from derived column transformation step in sort section of window settings.

></p>
<ul>
<li>In Windows columns, give the column name <code>Priority_new</code> and expression as <code>rank()</code>.</li>
</ul>
<p><img src=”https://i.imgur.com/qrMRrOh.png” alt=

Below is the output data.

https://i.imgur.com/KUMGVij.png” alt=">

友情链接