Crosstable and use of pick

[chiso_chiso]

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.

[Gysbert_Wassenaar]

I don't understand what you're trying to do. Can you post a document that demonstrates the problem?

[chiso_chiso]

Find attached.

Regards

[Gysbert_Wassenaar]

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.

[#5]

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

[chiso_chiso]

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?

[danieloberbilli]

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.

[chiso_chiso]

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.