how to writer optional prompt in derived table.

[rameshparchuri5]

hi ,

i have one derived table. object1 write the @prompt inside the derived table. but user request to need to Optional prompt
for that object . so how to write

logic is : object1 IN @Prompt('Enter value(s) for Product','A','Product',Multi,Free,Persistent,,User:2)

i try like this for Optional ,but it not working .any suggestions

object1 IN @Prompt('Enter value(s) for Product','A','Product',Multi,Free,Persistent,User:2,Optional)

Thanks,

[saurabh_sonawane]

Hi Ramesh,

In derived table we can't have an optional prompt.

Thanks,