Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Load
Product,
ArtiKelNr,
If(Match(Product, 'A','B','C','D'), 70, 85) as Percentage
Load
Product,
ArtiKelNr,
If(Match(Product, 'A','B','C','D'), 70, 85) as Percentage
Perhaps this?
If(Match(Product, 'A','B','C','D'), 70, 85) as Column_New
Hi Sai Kumar,
Use the below expression.
=if(match(Product,'A','B','C','D'),70,85)
Thanks All, worked perfectly!!