In my opinion, implementing complex logic in Qlik Replicate is not advisable. Instead, I suggest considering the following options:
Implement the logic and triggers in the target database tables; or
Utilize your own program to handle the logic for each row of data, including both Full Load and Change Processing. This can be done using a User-Defined Table Function (UDTF) as an example.
Additionally, I recommend considering a Professional Services (PS) engagement (fee-based) to help move the case forward if necessary.
Hope this helps.
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
