Generate New Column based on other column

[psk180590]

Hello All,

I'm pulling some data from a DB as in the below format, and would like to generate a new filed based on the data i have.

Sample Table:

Product	ArtikelNr.
A	1
A	2
A	5
A	10
B	15
B	20
B	30
D	50
G	80
F	20
C	30
E	50

Expected Result:

Product	ArtikelNr.	Percentage
A	1	70
A	2	70
A	5	70
A	10	70
B	15	70
B	20	70
B	30	70
D	50	70
G	80	85
F	20	85
C	30	70
E	50	85

So, basically if the Product is A, B, C, D i would like to populate the Percentage column as 70 and for all the other Products i would want 85.

Please, suggest the best possible way. Already tried doing Inline Load but, doesn't seem to work some how.

Thanks!!

[tresesco · Accepted solution]

Load

          Product,

          ArtiKelNr,

          If(Match(Product, 'A','B','C','D'), 70, 85) as Percentage

[Anil_Babu_Samineni]

Perhaps this?

If(Match(Product, 'A','B','C','D'), 70, 85) as Column_New

[Anonymous]

Hi Sai Kumar,

Use the below expression.

=if(match(Product,'A','B','C','D'),70,85)

[psk180590]

Thanks All, worked perfectly!!