Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to know if there are any restrictions for user with an analyzer license to use an ODAG applications. If it is so, can you please also explain which are these limits?
Thank you in advance
Sara
Hello, I'd like to use Aspose.total or Aspose.words in a talend job. Previously when we needed some third party jars (AWS secrets manager related), we downloaded the jars manually from mvnrepository.
However, in this case I don't see any jar files on the Aspose website or on mvnrepository. I only see the xml for the pom.xml. See below.
<dependency> <groupId>com.aspose</groupId> <artifactId>aspose-words</artifactId> <version>24.2</version> </dependency>
Do I need to manually insert that xml into the talend pom.xml? The tLibraryLoad component seems to assume that you have access to the physical jar file, which I don't have.
I'm a decent talend developer, but I don't have much experience with third party libraries.
Hi All,
I have to find the max date(MMYYYY) in which filter value PCAAT00 and PJABF00 must available for bate c.
Here i attaching the data set for reference.
max mmyyyy is 022024.
max({<bate={'c'},filter={'PCAAT00','PJABF00'}>}MMYYYY) ---032024 which is wrong
Thanks.
Hi, i need to convert Datetime to Integer in Talend
- First i convert datetime to string
TalendDate.formatDate("yyyy-MM-dd HH:mm:ss:SSSS",row4.TimeStamp)
- Second i convert string to integer
StringHandling.LEFT(Var.var1,4) ==> as var2 (for getting date in expression)
Integer.valueOf(Var.var3) ==> (in output table)
but get wrong like below
There is no null data from the original table.
Then I added the following command and the data was successfully streamed but something went wrong in the YEAR column
Var.var2!=null?Integer.parseInt(Var.var2):null
the result
The year column contains a NULL value and the data contents in the YEAR column are not aligned with the rows so they do not match the TimeStamp column.
Can you help to resolve this problem?
Tengo una tabla con columnas creadas por condicionales, y quiero mostrar un KPI que me sume todos los unos que hay en la tabla de las dos columnas que señalo.
- count
- Real vs Requested
Como vemos el sumatorio de la columna da 4 y el Kpi me esta dando 1, por lo que no entiendo porque me da distinto si la función que he puesto en KPI es un agregate de esa columna, (adjunto foto)
Esta es la función del KPI de Real vs Requested
My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT.
Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is UTC.
My Analytics data (retrieval_time) is showing as matching Eastern Time values.
What I'm concerned about is (a) I need all my analytic data to be stamped by UTC and (b) conversions become complicated with DST.
What is the best way to get my analytics data by UTC time?
I have thought of altering the TZ at the windows OS level, but concerns this could affect other dependencies like maintenance & patching processes.
Any "best practices" anyone could share?
Thanks.
Hello, I want to take avarage. The chart shows sales amounts on a weekly basis. I want to plot the average order quantity on the chart. In straight line shape.
If we have an application with our organisational data on Qlik SAAS Cloud, does it mean it is exposed to qlik vendor , how the security provided to our data on Qlik saas Cloud?
Hello ,
I want to create a fiscal year master calendar and I have used the below script :-
//-- Fiscal year Mastr Calendar---//
QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
Temp:
Load
min(EMLC_OK_DATE) as minDate,
max(EMLC_OK_DATE) as maxDate
Resident ZZ_FF_BUILD_DETAIL_DAILY;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
MasterCalendar:
Load
TempDate AS EMLC_OK_DATE,
week(TempDate) As RFS_Fiscal_Week,
Year(TempDate) As RFS_Fiscal_Year,
Month(TempDate) As RFS_Foscal_Month,
Day(TempDate) As Day,
// YeartoDate(TempDate)*-1 as CurYTDFlag,
//YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
date(monthstart(TempDate), 'MMM-YYYY') as RFS_Fiscal_MonthYear,
ApplyMap('QuartersMap', month(TempDate), Null()) as RFS_Fiscal_Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as RFS_Fiscal_WeekYear,
QuarterName(AddMonths(TempDate,3)) as RFS_Fiscal_QuarterName,
WeekDay(TempDate) as RFS_Fiscal_WeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
exit script;
//==============================//
But I am not getting the proper output. Please see below :-
Not sure, what mistake I made in the above script. Can anyone please help me ?
Thanks in advance
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Get to know these Qlik experts driving innovation and excellence in data, analytics and AI.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!