Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.
Hi all, I am currently encountering an issue when I run a Talend Job that read a query from Snowflake which is able to run in my local PC Talend but not in a Remote Engine that I have connected in Talend Portal. Here is the log:
tDBInput_1 Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
java.io.IOException: Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:138)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at fpi_dw.tcurr_0_1.TCURR.tDBInput_1Process(TCURR.java:3704)
at fpi_dw.tcurr_0_1.TCURR.tDBRow_1Process(TCURR.java:2622)
at fpi_dw.tcurr_0_1.TCURR.runJobInTOS(TCURR.java:7710)
at fpi_dw.tcurr_0_1.TCURR.main(TCURR.java:7142)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27).
at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:243)
at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:131)
at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:135)
... 5 more
From my PC, works perfectly:
Talend Portal:
Appreciate with any advice and feedback, thank you!
Hi, what do i miss here??
if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift
Hi,
I try to concatenate these 2 tables and the fields from the budget one (.xlsx) results in nulls as you can see in the image attatched, where I know there are values. Is there something wrong?
Many thanks!!!
This is the code:
The D-Link 5GHz Not Showing if your device does not support the 5GHZ network. Also, check and update the SSID names for both networks and sometimes it can happen due to a corrupted network adaptor. So to resolve it, give a different name to the 5ghz network and fix the adaptor issues.
Hello
we want to transfer data from db2 for z/os -> Postgres once a time with a FULL LOAD task for a group of tables.
Is it possible to perform this without enabling CHANGE DATA CAPTURE on that group of tables ?
Thanks
AF
Hi All,
I am trying to get some data out of an database. However, the load script does give an error in Qlik. When I run the SQL statement in the database, there occurs no error.
See below the error and the SQL statement.
Select
a.FK_BUDGETORDERINTAKEYEAR,
a.BUDGET,
a.MARGE,
a.BUDGETPRODUCTION,
a.PK_U_BUDGETORDERCATEGORY,
a.FK_BUDGETORDERCATEGORY,
a.FK_BUDGETSERVICECONTRACTTYPE,
a.INVOICEORDERINTAKE,
b.PK_R_ORDER,
b.FK_ORDERCATEGORY,
c.PK_R_SALESORDERDETAILMISC,
c.NETSALESAMOUNT,
c.ORDERDATE,
//c.FK_SALESPERSON,
d.FK_FINANCIALYEAR,
d.PRODUCTIONPERCENTAGE
FROM U_BUDGETORDERCATEGORY a
LEFT JOIN R_ORDER b ON a.FK_BUDGETORDERCATEGORY = b.FK_ORDERCATEGORY
LEFT JOIN V_R_SALESORDERDETAILMISC c ON b.PK_R_ORDER = c.FK_ORDER
LEFT JOIN U_PRODUCTION d ON c.PK_R_SALESORDERDETAILMISC = d.FK_SALESORDERDETAILMISC;
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!