topic Re: How to handle data transformation error in User-Defined Transformations? in Qlik Replicate

How to handle data transformation error in User-Defined Transformations?

nuttawut — Tue, 10 Nov 2020 09:49:07 GMT

How to handle data transformation error in User-Defined Transformations?

I use SQLITE_ERROR but task still run to the end not put into Queued or Error.

Thank you.

Re: How to handle data transformation error in User-Defined Transformations?

nuttawut — Tue, 10 Nov 2020 09:54:05 GMT

I would like to error table and then fix issue to reload that table only

Re: How to handle data transformation error in User-Defined Transformations?

Barb_Fill21 — Fri, 13 Nov 2020 19:25:47 GMT

Hi nuttawut,

Do you have a verbose log for this, if so can you please attach it?

I looked at your screenshots and this a little difficult to know exactly where the problem is happening.

In the meantime, I noticed you are at an early version of Replicate 6.6. We have many fixes for Sql Server and you may want to consider applying the latest Service Release (SR03) to be current. If you choose to apply the latest Service Release, please re-run the task again to see if the error occurs, again.

Sincerely,

Barb

Re: How to handle data transformation error in User-Defined Transformations?

nuttawut — Mon, 16 Nov 2020 02:46:53 GMT

Hi Barb_Fill21,

Thank you so much for asking. This issue is related to all source systems that have column naming with special character and need to be used in expression transformation.

like col name - Address$1, Address$2, Address$3 and we would like to concat Address$1+Address$2+Address$3

but expression transformation disallow '$' value so we open a QDI technical support and he said to raise FR in this community.

Please let me know if there is some unclear understnding.

Best Regards,

Thank you.

Re: How to handle data transformation error in User-Defined Transformations?

Barb_Fill21 — Tue, 17 Nov 2020 14:00:51 GMT

Hello nuttawut,

Thanks for your clarification. I agree, this is a feature request. Please click on the link below to make the enhancement request.

To get started please see our article: "Getting Started with Ideas": https://community.qlik.com/t5/Qlik-Product-Insight-Blog/Getting-Started-with-Ideas/ba-p/1684011

Let us know if you have any other questions!

Sincerely,

Barb