how to combine the two similar fields into one field

[#1]

Hi All,

status	close_flag
closed	-1
>closed	-1
cancelled	-1
chlid ticket	0
child ticket….	0
complete	0
completed	0
closed-app	-1
open	0

in the above table close_flag = -1 to combine the all closed fields into one closed field ,child ticket and child ticket.... both are same to combined  this two  into one filed like child ticket and also complete, completed both are same. to combined the this two into one field like completed . Then after to calculate the the count status in expression tab how to calculate the expression without using wild match and match function. any one plz tell me....urgent 

[anbu1984]

Check this

[MK_QSL]

Create one more field in your script...

IF(WildMatch(Trim(status),'*close*'),'Closed',

  IF(WildMatch(Trim(status),'*ch??d ticket*'),'Child Ticket',

  IF(WildMatch(Trim(status),'*complete*'),'Completed',status))) as NewStatus

Now create a straight table

Dimension

NewStatus

Expression

COUNT(Distinct close_flag)

or

COUNT(close_flag)

[#4]

Thank you anbu cheliyan

[#5]

Thank you Manish

[MK_QSL]

Please close the thread by selection appropriate answer if you got your answer..

[#7]

how to close the thread 

[MK_QSL]

You have to select Correct or Helpful answers from same screen shown below..

Whenever someone answering/replying your thread, you will see this screen below reply.. you can select only one correct and two helpful answers... By selecting correct answer will close the thread... This will help other members who have got the same type of problems...

[#9]

Try using Compress() function

[#10]

click on ur question it will refresh the window then u will get options like correct answers and helpful answers