Hello everyone,
I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table:

I have an expression that should return the records that are at the intersection of scenarios 204 and 208, but it returns records from other scenarios as well, such as 104, 107, 108, etc., as can be seen in the following table:

This is the expression:

=count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>})>} ID_CARD )

If I use the filters and select only the scenarios I want, I get the result I expect:

But, I need you to give it to me without using the filters.

I hope you can help me.
Thank you very much

Hi People,

I have installed the app Sense-Script-Load-Analyzer.qvf,

and changed the app owner - as requested.

When loading, I get the error mesage:

Connection monitor_apps_REST_app not found.

Any idea how I an resolve this?

Are there any alternatives for this tool?

Thanks!

Hello all,

I would like to exclude Region filter from my expression but the below listed expression is not working. I have If condition for an aggregated dimension and trying to exclude Region filter. Please suggest.

= Count({<Region= >} Aggr (If ( Status = 'InProcess', Status <> 'Complete'), Commodities, Commodities))

Thanks.

Hello Everyone,

I am currently using tHTTPRequest Component.

I've encountered an issue that rising an urlmaxlength error : "this request exceeds the configured maxUrlLength value"

I've looked for help.talend.com to find if it is possible to modify this parameter ? (and where)  

But I've found nothing yet.

Does anyone have any ideas?

Thanks by advance for feedback.

Best regards

Samuel

PS : Talend big data edition (studio v7.3.1)

Hi, 

We've been getting Talend Run Errors due to data entries with special character/ emojis. What we do is to locate that and update it. Is there a better way that these entries can be processed without getting rejetced?

Sample error log:

java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x87\xAE\xF0\x9F...' for column 'attendee_orgn_alias_nm' at row 3844

Hi,

A small problem here, the master item menu just appeared somehow (left side of the screen) and I can get rid of it, someone has a solution for this situation?

Thanks in advance!

Date     Shift   Job#

Jan3       1         X

Jan3        1        Y

Jan4        2        Y

Jan4        1        X

Trying to get a shift count for above example. Same date should count as 1 time.   Correct answer will be Shift 1 = 2 times,   Shift 2 = 1 time

I don't want shift 1 being counted twice on Jan 3.  Thanks in advance for the formula to consider.