maxstring to return data if contains Y

[dmxmikey]

Im trying to return word Egg on my table on Field that says Y and Blank if its N of blank.

Database contains Y,N and blank

[Anil_Babu_Samineni]

This is the case, I don't think whether you need MaxString(). Why not simply IF condition without MaxString() function

[sunny_talwar]

Where exactly are you using Y, N? on which field I mean?

[dmxmikey]

The Y,N is the alg-stat

[dmxmikey]

sorry how will the if command look like?

[sunny_talwar]

But you are testing for values such as GLUT, EGG against alg-stat? Does it contain both?

[Anil_Babu_Samineni]

My intention is this?

Load Distinct [p-code],

[alg-code],

If(Match([alg-code],'GLUT','EGG','CRUS'), 'Y', 'N') as Flag

[dmxmikey]

	Alg-code
Cake	Y
coke	N

the data looks like this on Database, where Y,N are Alg-stat,

so what i need to achieve is where Y i need it to say Egg and N to be blank. This is just for the Egg Alg-code

[dmxmikey]

Alg-code
Cake	Y
coke	N

the data looks like this on Database, where Y,N are Alg-stat,

so what i need to achieve is where Y i need it to say Egg and N to be blank. This is just for the Egg Alg-code

maxstring to return data if contains Y

[Anil_Babu_Samineni]

May be this?

Load Distinct [p-code], If([Alg-code]='Y', 'Egg', 'Blank') as Egg;