Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
How to recode by mapping with condition ?
I have below script work fine , when SOURCE=Q_DOD_20167
ApplyMap('MapGroup',GROUP_CLASS,'OTHERS') as [GROUP_CLASS_]
So that i can achieve below :-
When SOURCE = Q_DOD_2016 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-GL ( Correct )
nOW When SOURCE = Q_FCKL09 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-GL ( Wrong )
hOW TO MAKE SOURCE = Q_FCKL09 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-KL ?
Hopw some one can advise me.
For testing my QVW , pls unzip the file and copy all the file to C:\TEMP
Paul
Sorry to say but why you are not creating a simple example or sample document to work!
The current example requires lots of work for anyone to answer.
Better you create a sample excel file with only necessary fields for this question and upload it.
Hi Manish
You got the point. I think i should re-post again. Thank you for your feedback.
Paul Yeo
Hi Manish
I cannot further simply my sample doc. may be i should just enclosed the QVW.
Hope some one know the solution can share with me.
I also notice that most of the expert there , they don't even need to look at my simple doc and can suggest me the solution,
Paul