Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table with these columns:
ARTICLE CATEGORY MATERIAL
I would like to create a new column "Master Category" with these conditions:
IF CATEGORY='categoryName' and MATERIAL= A or B then MASTER CATEGORY='master1'
IF CATEGORY='categoryName' and MATERIAL='C' then MASTER CATEGORY='master5'
IF CATEGORY='categoryName' and ARTICLE = 'article name' then MASTER CATEGORY='master4'
IF CATEGORY='categoryName' and MATERIAL='C' then MASTER CATEGORY='master7'
IF CATEGORY='categoryName' and ARTICLE = 'something' then MASTER CATEGORY='master9'
ALL OTHER CASES MUST BE MASTER CATEGORY='Not defined'
Try this
IF(
CATEGORY = 'categoryName' AND (MATERIAL = 'A' OR MATERIAL = 'B'),
'master1',
IF(
CATEGORY = 'categoryName' AND MATERIAL = 'C',
'master5',
IF(
CATEGORY = 'categoryName' AND ARTICLE = 'article name',
'master4',
IF(
CATEGORY = 'categoryName' AND MATERIAL = 'C',
'master7',
IF(
CATEGORY = 'categoryName' AND ARTICLE = 'something',
'master9',
'Not defined'
)
)
)
)
) AS
[Master Category];
Hi @ValeriaBonini
Please try the below
IF(CATEGORY = 'categoryName' AND (MATERIAL = 'A' OR MATERIAL = 'B'), 'master1',
IF(CATEGORY = 'categoryName' AND MATERIAL = 'C', 'master5',
IF(CATEGORY = 'categoryName' AND ARTICLE = 'article name', 'master4',
IF(CATEGORY = 'categoryName' AND MATERIAL = 'C', 'master7',
IF(CATEGORY = 'categoryName' AND ARTICLE = 'something', 'master9', 'Not defined'))))) AS [Master Category];