Gaia Paolini

can you specify what TIBCO product you are referring to?

can you clarify Can the text area not already have a property control of type label, of which you can change the content dynamically when you populate the document property with a different image I mean, why do you need to recreate the property control itself with a script

Hi, please see these general tips /wiki/quick-tips-asking-community-questions

This seems a general Python question, not related to Python data functions in TIBCO Spotfire. There is a Stack Overflow discussion and possible answer for a similar question here: https://stackoverflow.com/questions/14693701/how-can-i-remove-the-ansi-e...

there is a duplicate (almost) of this question here /questions/how-remove-rows-same-column-values-two-data-tables-0

Also, if your question refers to a specific error, I recommend that you open a support case for this in the TIBCO Support Portal (https://support.tibco.com), and the support team can assist you with further troubleshooting.

To ensure that any responses are relevant for the particular TIBCO product that you are using, please add a note about what that product is (or edit the question, and select a product in the Product field)

If you want to calculate the average of days to file expense depending on timeliness, as a percent of the total days to file expense, you could try this: Sum([Days to File Expense]) over ([Timeliness]) / Sum([Days to File Expense]) * 100 This would give you a column with two values, one for Late and one for On Time.

The values in yellow do not appear anywhere else on the file. Can you clarify the example

P10 or P90 are similar to e.g. a Median line. If you take it on all data, it is a single value. Can you elaborate on how you need this to be calculated and maybe give a visual example

By slightly reworking the first part of your expression it seems to do what you wanted, at least for the example provided: RXReplace(RXReplace(Lower('test and test (tat)'),"\b([a-z])","\U$1","g"),"(!^)(A|An|The|This|And|But|Or|For|Nor|At|On|In|For|Since) ","\L$1 ","g") I put a word boundary \b there so it should match any transition from a non-word character to a word character. Seems ok also for matching the start.

You don't need Iron Python and yes limit data by expression would work. So your use case is: the document property is a string containing: - either a single value, with a $ in front - or multiple values, comma separated This expression would work for that: Find(Concatenate([YourVariable],','),Concatenate(Substitute('${YourDocumentProperty}','\$',''),','))>0 Substitute() gets rid of the initial $ if present Concatenate() on both probe and expression ensures you are not recognizing e.g. 1234 when your expression only contains 123.

Would this work CASE WHEN RXExtract(Concatenate(' ',Substitute(UniqueConcatenate([col3]) over ([col1]),',',' '),' '),Concatenate(' ',[col2],' '),1) is not null then 'exist' else 'not exist' end

is the colX you show the desired result In that case they should all be 'exist' because over the client1 there are cases in which col2=col3. I have the impression, from the way you describe it, that this is a stepping stone towards a goal (adding values) maybe you can elaborate

I am assuming there is one entry for Oil and one for Gas every Month. So something like this Sum([Volume]) over (Intersect([Month],[Field])) / 6 if not, please can you upload a test dataset.