如何组合每个促销Isroi值并比较它们(每个促销ID Is_Roi值) [英] How Can I Group Each Promotion Isroi Values And Compare Them(Each Promotion Id Is_Roi Values)
问题描述
我有专栏...
promotionid isroi
12 y
12 N
13 n
14 y
15 n
15 n
16 n
16 n
16 n
16 y
促销类型栏应显示促销类型。
如果促销至少有一种配置为 IsROI = y
的投资类型,则促销类型将为ROI
。如果促销包含所有'n'
值,则必须显示'NONROI'= False
。
输出将是
promotion_id promotion_type
12 ROI
13 NONROI
14 ROI
15 NOROI
16 ROI
I have to columns ...
promotionid isroi
12 y
12 N
13 n
14 y
15 n
15 n
16 n
16 n
16 n
16 y
Promotion Type column should display the type of the Promotion.
If the Promotion has at least one Investment Type that is configured as IsROI=y
then Promotion Type will be "ROI"
. If the Promotion has all 'n'
values then it has to display 'NONROI'= False"
.
Output will be
promotion_id promotion_type
12 ROI
13 NONROI
14 ROI
15 NOROI
16 ROI
推荐答案
你是上一张海报请告诉你你做了什么
我们会指导你
ok看到这个链接
are you the previous poster please show what you are done
and we will guide you
ok see this link
这篇关于如何组合每个促销Isroi值并比较它们(每个促销ID Is_Roi值)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!