WHY i don't have api designer in my talend cloud ?

at the moment, i'm using free trial version for 14 days, 

it's because i'm using a trial version ?

Hi all,

hope you guys are doing well. I have recently downloaded Qlik replicate on my windows laptop and the url from where i downloaded the Qlik replicate is "https://community.qlik.com/t5/Product-Downloads/tkb-p/Downloads". I am trying to populate a csv file into a local folder in my laptop. For source, endpoint is built using file and for destination endpoint is built using File Channel.

and it gave me this error

"

• Task cannot run.
• Express license: Target endpoint File Channel is not licensed under the Express license.
• Express license: Source endpoint File is not licensed under the Express license."

Hi everyone,

I recently switched from NPrinting 16 to NPrinting May 2023 SR3 and QlikView May 2023 SR1. My QVF/QVW document gets refreshed daily on the QlikView server.

Initially, I noticed that my NPrinting report worked once, but the next day it was sent empty (charts and tables were present, but no data). After tinkering in the NPrinting web console, it worked again once, but then the next time it was empty again.

Later, I discovered that I needed to schedule a metadata refresh to run before the publishing task. Is this the correct approach, or am I doing something wrong?

If scheduling a metadata refresh is necessary, is there a way to automatically trigger the report publishing right after the metadata gets refreshed?

Thanks for your help!

I'm not sure if this is relevant or not. The data in the report is dependent on a date parameter that gets passed from NPrinting filter which is usually today(1)-1  with evaluate ticked.

I am having some issues getting the REST connector to pull the data I'm looking for on RingCentral. I've set up a REST application in the development console on ringcentral.com, and they provided the following:

• Client ID
• Secret
• JWT credential
• URL to query

The REST connector in Qlik, however, just has User ID and Password in the credentials area, so I am unsure how to proceed. Is there a way to use Client ID/Secret/JWT in the Qlik REST connector? Perhaps there are query parameters that I can use to pass this information to the API (cannot find this info on their site). 

Thanks for any guidance!

Hi,

I am trying figure if there is a standard way I could put/maintain my company logo in all our NPrinting reports. Example we have hundreds of  NPrinting reports going out and we have added company logo in templates but if we were to change this we need to update it in each report. Is there a way we can standardize it, so that if we update the logo in one place all the reports gets updated for future reference.

Thanks,

Sikander

Hi,

I am using an SQL query to fetch previous day's data from an Oracle database. This query gives me data for just previous day. I need last 45 days worth of data on a daily basis.

Is there a way I can pass a variable for the highlighted section of the query snippet below so that I can run a loop and extract data for all the past 45 days... something like sysdate - $(vDateCount) in place of the highlighted section.

Regards,

Bhaskar

Hello there,

Is there any way we can filter/reject some records on a specific column in Tmap when using “Dynamic” schema type in Talend.

My source is Oracle and Target is Snowflake and am using schema type as "Dynamic" on both sides and I won't be able to see the columns.

my job looks like this currently:

tdbOracleInput - tmap-3 flows (1st one goes to tDBoutputsnowflake, 2nd one goes to a tFileoutputdelimited to store raw records and last one is where I want to capture the rejects).

Any pointers are very helpful.

Thank you

Nandu

Hi,

In my app I want to use qvd-files from the space where the app is located. I.e when the app is in shared space the qvd-files resides in shared space and when the app is in managed space it should use the qvd-files in the managed space. And I don't want to change the app once it is in managed space.

This can be solved by manually adding this in the script:

Let vSpaceType = GetSysAttr('spaceType');

// Figure out if this is shared or managed space
if vSpaceType = 'shared' then
Let vQvdExtractPath = 'lib://MySharedSpace:DataFiles/';
else
Let vQvdExtractPath = 'lib://MyManagedSpace:DataFiles/';
end if;

Data:
LOAD *
FROM [$(vQvdExtractPath)MyExtractedData.qvd]
(qvd);

But how can I set this when I fetch data automatically with data manager?


Kind regards
Johan

Stitch is a cloud-first, open source platform for rapidly moving data. A simple, powerful ETL service, Stitch connects to all your data sources – from databases like MySQL and MongoDB, to SaaS applications like Salesforce and Zendesk – and replicates that data to a destination of your choosing.

If you are new to Stitch or one of our Stitch experts, here is the place to ask questions and/or build up your reputation points by answering questions and offering up your Stitch life hacks to get stuff done.

Hi,

I'm following along the course Data Manager Associations, Concatenations and Joins.

On the 6th video, 'Concatenate Tables from Separate Sources into a Single Table', we are instructed to inspect the table 'OrderData' via the table editor, and keep the range of the field 'OrderDate' in mind.

In the video, the range is fully visible:

Value Range of 'OrderDate' field is presented in regular sized font, making the range fully visible

In the app I created with instructions from the video, the font size of the range is unnecessarily large, making the range only partially visible:

Screenshot showing the Value Range of 'OrderDate' field is so large.

As it can be seen in the screenshot, the final part of the value is omitted and replaced by ellipses, which kind of defeats the purpose of having the range summarized there. 

Is there any way to reduce the font size so the whole value is visible? 

I tried to use ctrl + '-' to change the size of the page, but comically enough, the font of every other text on the page decreased except for the range! I also thought maybe the value could be copied and pasted somewhere else for inspection, but that is not possible either. What can be done in this case to visualize the whole value?

Screenshot showing zoomed out page, where all the text has been scaled down to reflect the zoom change, except for the value of interest, which actually seemed to increase in size.