Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have one field Which is consist diff values,in that i want only Q1,Q2,Q3,Q4
How to get this?
can u explain more?
u mean default selections or always one selectd values?
What i want is
if Q1-F12, Q2-F12, Q3-F12, Q4-F12, is there ,i want only Q1,Q2 Q3 Q4;
also I want What selected in the Screenshot.
try this
if(Match(quarters,'Q1','Q2','Q3','Q4'),quarters) as new
H
50% okay
Its picking only Q1,Q2 Q3 Q4;
also i want
if Q1-F12, Q2-F12, Q3-F12, Q4-F12, is there ,i want only Q1,Q2 Q3 Q4;
also I want What selected in the Screenshot.
Do you just want to filter out Q1-F12 from the list box or do you want to rename them to Q1?
If renaming, then may be this:
Pick(WildMatch(Quarter, 'Q1*', 'Q2*, 'Q3*', 'Q4*'), 'Q1', 'Q2', 'Q3', 'Q4')
LOAD *, if(wildmatch(Quater, '*'&Q1&'*') or wildmatch(Quater, '*'&Q2&'*'),1,0) AS Flag
try lik dis