thank you very much Antonio for this as it is very helpful. Couple of questions here:
1. Under the Expressions - -> Conditional Check Box you have entered a formula as: SubStringCount(Concat(Fuel,' '),'Coal'). What does this mean here and what is the condition based on the count of fuel type occurrence?
2. In the inline statement, you have mentioned:
LOAD * Inline [
Does it mean that Inline table created can be referred by the first entry, i.e. 'Fuel' anywhere (like you have used it in Listbox Field?
Thanks again, Anand
Thanks for your prompt reply Antonio. and sorry to be naive there, but I thought SubStringCount(Concat(Fuel,' '),'Coal') function will return a number "1" in this case as coal would be appearing once in the list. How does 1 here translates to that the condition is met? Does 1 or any value more than 1 signifies 'TRUE' here? thanks, Anand