Hello Experts,

I'm working with a set of sales data I've encountered an issue with "Previous Month" measures.

The measure is intended to sum the "Amount" values from the previous month based on the maximum date selected, but it returns zero even though there are relevant data entries.

Below is my Data

Measure for Sum of Amount for Selected Month (Working Correctly):

sum({<SalesDate = {">=$(=MonthStart(Max(SalesDate)))<=$(=MonthEnd(Max(SalesDate)))"}>} Amount)

Measure for Sum of Amount for Selected Previous Month (Returning Zero):

sum({<SalesDate = {">=$(=MonthStart(AddMonths(Max(SalesDate), -1)))<=$(=MonthEnd(AddMonths(Max(SalesDate), -1)))"}>} Amount)

I have attached my QVF File as well.

Could anyone help identify why the measure for the previous month might be returning zero and suggest how to fix this issue?

Thank you

Hi all,

How can we determine if the dashboard has successfully reloaded after a failure without manually checking it? We would like to receive an email notification about this. Is there any way to achieve this? Please help.

We currently receive alert emails for failed reloads, and we would like to also receive alerts for successful reloads following a failure,

If above one not works ,we would like to receive a single email by the end of the day summarizing all load history, including both failures and successes

Thanks 

Hi Team,

After upgrading TDC to version TDC-8.1-20240419, we encountered this issue while setting up SQL Server in TDC. MITI/bridges/javabridgeinterface/MimbGenericOperationBridgeInterface; nested exception is: MITI.sf.client.axis.gen.MimbAgentFault: MITI/bridges/javabridgeinterface/MimbGenericOperationBridgeInterface. How to resolve this error .please find snapshot.

Thanks 
Mrunal

In a Talend 8 job I need to read messages form an Azure Storage Queue.

The options for this are tAzureStorageQueueInput and tAzureStorageQueueInputLoop

The problem with the tAzureStorageQueueInput is that it can retrieve a maximum of 32 messages per run instead of just collecting all that is there in the queue.

The problem with the tAzureStorageQueueInputLoop is that it never breaks out of the loop, how would I know it can safely terminate? In the documentation there is nothing mentioned on how to stop this infinite loop.

Documentation used: https://help.talend.com/r/en-US/8.0/azure-storage-queue/tazurestoragequeueinputloop

Hello, i have built a LastMonthFlag and it correctly grabs April, but i only want it to grab April of the current year.  How do i achieve this? It is currently grabbing April for every year in my dataset. My code is below.

IF(Month(datefield) = Month(now())-1,1,0) as LastMonthFlag

Please help me achieve this, thank you!

My Task without filter condition has already completed full load, now I want to add a new filter condition for CDC records to exclude some records based on source column value.

I tried with adding below filter condition and record selection condition but both scenarios I am  getting weird results:

Col Name is Cloud_migrt_ind.

• CLOUD_MIGRT_IND

  STRING(1)

  Regular

  Exclude

  'Y'

•  $CLOUD_MIGRT_IND != 'Y'

Can you suggest the best way to add filter condition to exclude record based on column value ?

Thanks,

Srinivas 

Hi team, 
I have a doubt regarding creating filter conditions for a column, in the attached image I have used two filter condition, I'm having a requirement were I want to use more number of filters that maybe in thousands(using python API QEM) , is it possible or can I know whats the maximum number of filters I can use.

Thankyou
Regards
Sreehari