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.

We need certified Qlik consultants as freelancers (this is not a regular job opportunity)

If you are interested please kindly check www.experdeep.net or send us an email at agent@experdeep.net

Thanks

Hi guys, I am a DE/DA with 1 yoe , till now my job was to communicate with business users and other data analysts and write SQL queries to create Daily/Monthly data reports in for of SQL tables, I was hoping to learn python or some data Engineering tools in future but my company has asked me to do a certification in qlik replicate and I have never heard of any organisation using this tool , so I am scared that I might be wasting my time doin this and might get stuck in this stack, any help would be really appreciated

Hey community!

I have been using AWS DMS for quite a while, but now I'm interested to implement it on my own, because of the limitation it has.

Does anyone know what is used under the hood?

I mean, I understand there may be a custom solution written, but often AWS takes some open-source and wraps that.

Hi everyone, I know this might have been asked a lot, but none of the solutions seem to work.

In my talend job I have the following

The readmessage component reads from the cachemessage component. however sometimes I get tHashInput_1 The hash is not initialized : The hash must exist before you read from it

Do you have any idea how can I add an initialization check?

I have requirement to create a pivot table in Qlik Sense with a dimension and couple of measures to be added as dimensions (synthetic dimensions) by aggr with that dimension to show them freeze while scrolling the horizontally.

The problem is, I also need to show totals row for the synthetic dimensions as well like in excel. Is there any solution for this?

@Michael_Tarallo  @sunny_talwar