create new column in information steward based on condition

[former_member669887]

Hi All,

i want to add a new column in information steward view but i want to put a condition per below example

if the result column is having 'missing' the new column should be filled with Missing country if the result column is populated then it should be kept blank

Material plant Result New column 132 3210 Missing Missing country 3330 3210 Poplulated

[former_member690658 · Accepted solution]

Hi Abdul,

You can add new the column in view and in Mapping you can write either "If-then-else" condition or "Decode" will also work very fine.

For example you can use like:

Decode( DBName.dbo.TABLENAME.COLUMNNAME='Missing', 'Missing country', DBName.dbo.TABLENAME.COLUMNNAME)

Let me know if any issue. Happy to Help 🙂

[former_member669887]

thank you Ajit it worked