Which Condistion working

[kulasekhar]

Hi All,

Greetings for the day!

I have bellow table.

LOAD * INLINE [

    FACTORY_NAME,NUMBER, BASECUT 

    IND,1, IN_PRODUCTION

    IND,2, TERMINATED

    IND,3, IN_PRODUCTION

    IND,3, TERMINATED

    IND,4, IN_PRODUCTION

    IND,5, TERMINATED

    IND,6, IN_PRODUCTION

    IND,7, TERMINATED

    IND,8, IN_PRODUCTION

    IND,8, TERMINATED

];

Condistion: When ever showing one NUMBER only IN_PRODUCTION then IN_PRODUCTION

                  When ever showing one NUMBER both IN_PRODUCTION and TERMINATED then IN_PRODUCTION

                  When ever showing one NUMBER only TERMINATED then TERMINATED

Please find the same table attached QVW.

Thanks

Sekhar.

[antoniotiman]

Hi Sekhar,

see Attachment.

Regrds,

Antonio

[kulasekhar]

Hi Antonio,

Can we write in script level. above solustion mine it's not working.

Thanks

Sekhar.

[antoniotiman · Accepted solution]

See Attachment