If i understood the concept. You need to load the entire dataset first. After that you need to check the whether the field is null or not. If the field is null then drop that field otherwise drop another field.
A,B,C are the fileds
If A is null drop the field A otherwise C.
- If you provide sample application we can work on it.
I'm working on a designer license through my work with the script already set and data loaded I'm just adding in fields to tables and designing a webview for other users so I can't provide an application sample.
I can get the field names I mentioned in seperate columns but as the values only appear in one column or the other I wanted them combined into one column in the table using an expression. Is this possible?