Hi ,

I need to parse and load DB a pipe delimited file having data in the below structure using Talend.

Col1|Col2|Col3

"abc|111"|100|"zzz"

"xyz|222"|200|"yyy"

• Text fields are enclosed in double quotes.
• Few text columns contain the delimiter inside them.

I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).

Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.

Please help.

Thanks

Hello Qlik Community,

We have migrated the server application data which is D(net app) drive to some F(pure) drive for the storage migration activity from net app to pure.post that we have renamed that F drive to D drive by stopping the services for both Qlikview and nprinting with the help of only Qlikview admin credentials.

Then we restated the server and started checking the qlikview and nprinting applications.

I'm able to open qlikview QMC and access point but somehow Nprinting credentials are not working for me to login ,even the admin credentials are also not working.

I'm not sure ,if this is because of the storage migration or due to the drive letter change and there is nothing changed in C drive where the application is installed.

Please let me know is there anything I need to check on this immediately.

Thanks in advance. 

Hi, what is the status of a request to add a MinIO connector please? This closed thread has a link to an idea on the ideation site, but I do not have permissions to view it. (I assume that is the case for others as well.)

Thanks

Hey everyone, I'm seeking some advice:

I need to read an XML settings file and parse it to extract its contents into multiple property files, one for each environment. Everything seems to be working smoothly, but the filename is lazily set and does not match the content

Thank you

Hi,

I have deployed the app Application Automations Monitoring v1.1 in the SaaS tenant and was reloading successfully till last month. 

https://community.qlik.com/t5/Official-Support-Articles/How-to-automation-monitoring-app-for-tenant-admins-with-Qlik/ta-p/2025392

Now, the reload fails with error below. No changes have been made to the data connection. 

Any ideas on how to fix it?

Hi, I'm working in Talend Studio, and I need to run 2 jobs which contain data services at the same time to test a route. I get an error because they cannot be run in same port (8090). Is there any way to set a different port when you run a data service?

Error message:

Endpoint deployed at: <localhost>:8090/ <myEndPoint>
[statistics] connecting to socket on port 3717
Exception in component tRESTRequest_1_Loop (<myDataService>)
java.lang.IllegalArgumentException: Cannot start provider with uri: <localhost>:8090/ <myEndPoint>. Port 8090 already in use.
at XXXXXXX.<myDataService>.checkEndpointUrl(<myDataService>.java:1250)
at XXXXXXX.<myDataService>.tRESTRequest_1_LoopProcess(<myDataService>.java:5300)
at XXXXXXX.<myDataService>.runJobInTOS(<myDataService>.java:6863)
at XXXXXXX.<myDataService>.main(<myDataService>.java:6171)

We wanted to Convert a numeric value to String and then check the length of the string and if it exceeding 255 we need to get first 255 char or we need to load it as it is.

Below is the Code we are using , the case statement is working as the data is coming as numeric the code is failing

case when
length($code_value) > 255 then substr($code_value,1,instr($code_value, ";")+250)
else
$code_value
end

Is there a way we convert numeric to string.

We run Replicate and Compose on-prem, writing to a SQL Server instance also on-prem. Our DBA has scheduled 4-hour backups for all the company's SQL Servers which is supposed to truncate the transaction logs for all the databases after doing so. However, the logs for both my test and production data warehouse databases seem to be immune to such truncation:

Notice in particular the fact that the log for the test data warehouse is actually bigger than the test data warehouse itself!

Any systems-knowledgeable folks out there have any insights?

Is there a setting in Replicate that I have inadvertently toggled to cause such behavior?

Qlik Replicate 

I need to modify an existing P&L table with several scenarios (using the Vizlib solution with external Excel table).

Is is possible in a P&L table to use different factors per line?

sum(  Value* $(=PL_View_Factor_Best) )

I get the right calculation, when the factor is the same for all lines, but when using different values or even an conditional value for different scenarios, it returns no value.

Is there another/better way to solve this?

i have dat like below in postman request

in qlik connection i am using nextUrl as my pagination 

Next Url path :paging/link

it bring only one page can you help here