Hey Gang,

We've got on-prem Remote Engine(s), mutliple developers using instances of Studio around the globe.

Readying ourselves for an upgrade from 2023-08 to 2024-06. 

I've successfully installed 2024-06 locally - and have a testing branch which is going just fine so far.

Here's my open un-answered question:

Once we go forward & set the upgrade settings in Talend Management Console >> Configurations >> Studio

1. what happens next?
2. What are the chain of events that occur next time developer opens their studio?
3. Do the artifacts in TMC Cloud get updated automatically?
   1. If they don't - do they need to be updated?
4. Does the "main" branch need to be converted & pushed to cloud?

Thanks - this is our first production upgrade, and just want to understand the moving pieces that are going to happen & what the order of events to plan for.  The documentation lacks this playbook.

Thanks, Tim Ouimet

Hi! 

I have the following chart:

This is basically value distributed by date. What I want is to create another bar chart where each bar will be the difference of the value between a specific date and 7 days before. For example, the 28/06/2024 needs to be showing me the value of 28/06/2024 minus 21/06/2024, then 27/06/2024 should be 27/06/2024 minus 20/06/2024, 26/06/2024 needs to be 26/06/2024 minus 19/06/2024 and so on...

This will be updated every day so a new date will be added on a daily basis. 

Thanks in advance!

I need to calculate as measure the sales of the last year based in the following straight table:

The field Period is defined in the script as a date, I tried to calculate the column Sales Last Year with this formula, but I don´t understand why the result in the mentioned column as 0.

Sum({<Period = {"$(=Date(AddYears(Period, -1), 'MMM-YYYY'))"}>} Sales)

Straight table:

Hola, tengo un problema al leer una tabla de SAP, puedo hacer la conexión a la base de datos pero al recargar me muestra el siguiente error.

I'm getting an error in our Qlik SaaS tenant where I cannot access scripts. I have all the rights/permissions required to access the script, and other users can open the same script.

Has anyone else experienced this and found a cause and solution?

Error code: RangeError: Incorrect locale information provided

Hi everyone, i have using the following code to get which service was first given based on the date,

but if 2 services are given on same date i am getting null as output , i would like to have both those records if same service date 

My code

by_first_month:
Load
id as id,
min(date(Service_dt)) as service_dt,
FirstSortedValue (Service_Group, Service_dt) as Service_Group_test,
FirstSortedValue (icode, Service_dt) as icode_test,
FirstSortedValue (amount, Service_dt) as amount_test,
resident [table]
Where Service_Group='test1 'or Service_Group='test 2 'or Service_Group='test3'or Service_Group='test4'
group by id;

In the above code i am filtering the records from table , where service_group is in test1 ,test 2 ,test3,test4

then i am finding the minimum of service date , and first sorted value based of other dimensions based on 

My aim is to get only records where we have min service date 

The problem is when 2 service_groups have same service date i am getting null, as output , 

any help will be appreciated Thanks

Hi all,

I am interested to do my QSDA 2022 certificate, pls let me know how to start studying and any dumps also can be shared and pls share your experience of preparing and successfully passed story. so it can be helpful for me to start.

Hi

I'm looking for some advice on the best components and approach to moving files around on an Azure Storage container.  

The use case I'm looking to deliver on is

1) Connect to Azure Storage Container

2) Move a specified file or set of files from storage container A to container B and create a sub folder in the target container B to store the files if this doesn't exist.

I assume someone in the community has performed this before, so I'd be keen to know how you've achieved it.

Thanks

Dave

Hello, I have 2 tables. Here, I want to calculate the working time if the date range in Table2 is within the date range of Table1, please help.I tried to write the code but unfortunately it didn't work.

My code:

OrderData:
LOAD
ORDERID,
STATIONID,
STARTDATE,
ENDDATE
INLINE [
ORDERID, STATIONID, STARTDATE, ENDDATE
UGR190643, 4932920, 2024-01-01 23:45, 2024-01-01 23:59
UGR190643, 4932920, 2024-01-02 00:00, 2024-01-02 15:30
UGR190645, 4932925, 2024-01-05 14:30, 2024-01-05 18:30
];

StationData:
LOAD
STATIONID,
STARTDATE AS STATION_STARTDATE,
ENDDATE AS STATION_ENDDATE
INLINE [
STATIONID, STARTDATE, ENDDATE
4932920, 2024-01-01 19:45, 2024-01-01 23:48
4932920, 2024-01-02 00:00, 2024-01-02 02:30
4932920, 2024-01-02 15:25, 2024-01-02 15:45
4932925, 2024-01-04 18:45, 2024-01-04 23:59
4932925, 2024-01-05 00:00, 2024-01-05 11:30
4932925, 2024-01-05 11:30, 2024-01-05 14:30
4932925, 2024-01-05 14:30, 2024-01-05 17:30
];

IntervalMatch:
IntervalMatch (STARTDATE, ENDDATE)
LOAD
STATION_STARTDATE,
STATION_ENDDATE,
STATIONID
RESIDENT StationData;

Left Join (OrderData)
LOAD
STATIONID,
STATION_STARTDATE,
STATION_ENDDATE
RESIDENT StationData;

FilteredData:
LOAD
ORDERID,
STATIONID,
STARTDATE,
ENDDATE,
STATION_STARTDATE,
STATION_ENDDATE
RESIDENT OrderData
Where STARTDATE >= STATION_STARTDATE and ENDDATE <= STATION_ENDDATE;

WorkingTime:
LOAD
ORDERID,
DATE(STARTDATE) as Date,
SUM(FLOOR((ENDDATE - STARTDATE) * 24 * 60)) AS WORKINGTIME
RESIDENT FilteredData
GROUP BY ORDERID, DATE(STARTDATE);

DROP TABLE OrderData;
DROP TABLE StationData;
DROP TABLE IntervalMatch;
DROP TABLE FilteredData;

Table1:

Table2:

ı want to result:

Thank you.