HELP! Can not get this ETL Formula to Validate

jtrollinger · 2023-05-15T20:54:55+00:00

There was an error rendering this rich post.

Can not get this ETL Formula to Validate

CASE WHEN HdrParentItemCode IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN'
ELSE
CASE WHEN HdrParentItemCode IN ('ZTOPOUT', 'ZGAS') THEN 'Topout'
ELSE
CASE WHEN HdrParentItemCode IN ('ZTRIM','ZDROPIN') THEN 'Trim'
ELSE
CASE WHEN HdrParentItemCode IN ('ZPUNCH') THEN 'Punch'
ELSE
'Others'
END

Find more posts tagged with

Accepted answers

GrantSmith

Only the first CASE keyword is needed you can remove the others but leave them when and clauses

MichelleH

@jtrollinger In addition to Grant's feedback, you only need one ELSE to designate 'Others'

GrantSmith

Good clarification @MichelleH

@jtrollinger it should end up with something like this

CASE WHEN `HdrParentItemCode` IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN'

WHEN `HdrParentItemCode` IN ('ZTOPOUT', 'ZGAS') THEN 'Topout'

WHEN `HdrParentItemCode` IN ('ZTRIM','ZDROPIN') THEN 'Trim'

WHEN `HdrParentItemCode` IN ('ZPUNCH') THEN 'Punch'

ELSE

'Others'

END

All comments

GrantSmith

Only the first CASE keyword is needed you can remove the others but leave them when and clauses

jtrollinger

Thanks Grant. Syntax is everything.

MichelleH

@jtrollinger In addition to Grant's feedback, you only need one ELSE to designate 'Others'

GrantSmith

Good clarification @MichelleH

@jtrollinger it should end up with something like this

CASE WHEN `HdrParentItemCode` IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN'

WHEN `HdrParentItemCode` IN ('ZTOPOUT', 'ZGAS') THEN 'Topout'

WHEN `HdrParentItemCode` IN ('ZTRIM','ZDROPIN') THEN 'Trim'

WHEN `HdrParentItemCode` IN ('ZPUNCH') THEN 'Punch'

ELSE

'Others'

END