Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Gurus,
I have a Crosstable with Attribute field called Question and Data field called Answers.
I would like to use PICK function to qualify some fields into a variable but I keep getting errors.
My statement is;
pick(wildMatch(Question,'*BLACK LABLE*','*BLK LBL*','*CASTLE LIGHT*','*CSTL LTE*'), 'Black Label','Black Label','Castle Light','Castle Light')
Kindly assist.
I don't understand what you're trying to do. Can you post a document that demonstrates the problem?
Find attached.
Regards
That document contains no data. And more importantly it does not give a single clue as to what the problem is that you're having trouble with.
The statement you are using seems fine to me. If you select 'BLACK LABLE' from Question listbox, don't you get 'Black Label' value in the variable?
Thanks,
Singh
Angad,
No its not being returned. Actually 'Question' is not even being highlighted as a field name when i am writing my expression. Is it because its a crosstable?
The attribute and data field should be accessible as normal fields. But your script and usage of variables is pretty complex - I think you need to include the actual data in your example to understand what is actually happening.
Find attached my model.
I have exit the script pre-maturely just to load the data as completing it is bringing the said errors.
Kindly assist.