When we load data through Qlik replicate, In Source we have a fields containing multiple values, Seperated by ;

For Example,

Field Name in source:  Tax

Value : 10;12;4

in target we want it to be flattened,

Tax1 field should have the value 10

Tax2 field should have the value 12

Tax3 field should have the value 4

We have written a expression and its working, is there any other simple maner if we can solve this issue, giving the logic we are using currently.

Tax1 :

 substr($TAX,1,instr($TAX, ";")-1)

Tax 2:
substr(substr($TAX,instr($TAX, ";")+1,length($TAX)),1,
instr(substr($TAX,instr($TAX, ";")+1,length($TAX)), ";")-1)

Tax 3:
substr(substr($TAX,instr($TAX, ";")+1,length($TAX)),
instr(substr($TAX,instr($TAX, ";")+1,length($TAX)), ";")+1,length($TAX))

I see from earlier posts (2021-02-11) that it is not possible to convert bookmarks from QV to QS.  

Did Qlik fix this issue or is it still not possible?

In source we have the data coming correct where as in target the array coulumns are occing as one column.

For example:

we have source columns as abc1,abc2, abc3, abc4, abc5 with values 19,0,0,2,4 in target data is loaded as abc with value 19;0;0;2;4.

For splitting each column I used below functions. please review.

abc1 : substr($abc1,1, instr($abc1,';')-1) = returns 1st value

abc2: SUBSTR($abc2, INSTR($abc2, ';') + 1 , INSTR($abc2, ';')-1) = doesnt return 2nd value instead returns 0;

Please help us in resolving this issue in qlik replicate.

Thanks in advance.

I am having my job running very well when Target Exec is set to localhost however when it is set to DataIntegration_RE_3(Environment:Development) it fails with the below given. I have gone through the documentation and made sure that the file org.talend.remote.jobserver.server.cfg has got the specific variables mentioned in the documentation (https://help.talend.com/en-US/remote-engine-user-guide-linux/Cloud/configuring-connection-between-talend-studio-and-talend-remote-engine) set correctly. Execution failed : org.talend.remote.commons.exception.ClientServerException: java.net.ConnectException: Server unreachable 10.52.0.56:8013, message: Connection timed out: connect [java.net.ConnectException: Server unreachable 10.52.0.56:8013, message: Connection timed out: connect] The version.txt in the remote engine has the following 2.12.5_Tipaas/tmc-engine/release%2FR2022-10-02_252_Engines/tipaas-remote-engine-build/master

Hi Team,

Could you please give some idea how to achieve multiple to address in for one email based on filter option in excel. I have followed below steps but not able to achieve

Receiving below warning in N printing side

Not find any selected items

Hi Community, 

we get the error Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\) when we click "Guess schema". 

We don't change the query and we get it in every job.

We are use a Microsoft SQL Server and Microsoft Server 2016 Datacenter. 

I tried to reproduce the error. I don't get the error. 

Talend Version: 6.3.1.20161216_1026 

I hope you have any ideas how we can fix that.

Thanks & Regards

Selina

The two, subject numeric fields figure into a finance report which also contains static text and many more numeric fields. The latter set of numeric fields are dynamic and their values change automatically as data in the App changes; and these field values appear just fine after the sheet is made Public to a User who has Private Analytics Content Creator, Shared Space Creator and Steward rights

The two, subject fields differ from the many additional numeric fields in that they are populated with measures using two separate input variable controls. Once these variable inputs are manually input, their values appear just fine in the Text & Image chart. However, they disappear when the sheet is made Public to the same User.

Can anyone explain the problem and how to fix it?

Thanks in advance!
Oliver

Hi all,

I have a dashboard with a filter of the field event_name and I selected all the events with the words amnesia 2024 in it. But I need to create a table to display all the events with the words amnesia 2023 in it. How could I do it?

Just in case it helps, I have 2 fields called event_code and a previous_event_code so the events of 2024 and 2023 are related that way.

I tried this but didn't work: 

={<year_event=, month_event=, event_code=p(previous_event_code), event_to_compare=, event_name= >} event_name

Many thanks!!

Hi guys, I have an input table with the % of comission for each Product Type Sale for each SalesMan. 

The table looks like this (in the real case the SalesManID is dynamic, it's not only for 4 salesman) :

And I'd like to get an output of a desired table like this :

Could anybody help me please? I don't know if crosstable it's the best option, I'm trying to do it but with no results.

PD : I've attached the example in excel, in order to make it easier for everyone to understand.

Kind regards, Marcel.