how to change filed data name and null to other name and apply filter

[nima94]

Hi every one

i have a filed with contains of bellow:

U

X

T

Null: blank no date

and i want to apply and combine both bellow,

Aggr(pick(match(CU_STATUS,'U','X','T'),'Used','NotUsed','NotUsed',),[CU_STATUS])

Aggr(if(IsNull([CU_STATUS]),'NotUsed',[CU_STATUS]),[CU_STATUS])

and i want the result as : USED or NotUsed

and i want to apply the filter as well

[vamsee]

Is this a part of a larger expression as I don't see the need of using Aggr() here. Anyway try 

If(Match(CU_STATUS, 'U', 'X'), 'USED', 'NOT USED')

[nima94]

Hi 

thanks for your reply, but i have many null fields that i want to show them as Notused

[Kushal_Chawda]

@nima94  try below

=if(CA_STATUS='U','Used','NotUsed')

[nima94]

same

[Kushal_Chawda]

@nima94  provide sample data to get accurate answer

[nima94]

Hi

thanks for you help and support please find the attached image

[Kushal_Chawda · Accepted solution]

@nima94  Logic I suggested should work like below

LOAD *,

           if(lower(trim([Voucher Status]))='u','Used','Not Used') as Voucher_Status_New

FROM table;