Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: SQL LookUp Queries

SQL LookUp Queries 1 year 4 months ago #18117

  • trally
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 52
  • Thank you received: 0
Hi Peter

In the attached Word document I have found a problem when there is no matching Base64 converted jpeg file found in the SQL LookUp process.
I cannot get the syntax right to have the process use a substitute Base64 item and when there is no matching record found it corrupts the contents of the Jason record.

Please check the attached zip files

I have emailed the 2 x Zip files as they result in a warning that they exceed the 2MB limit - they total less than 600K?

Regards

Please Log in or Create an account to join the conversation.

SQL LookUp Queries 1 year 4 months ago #18122

Hi Tral

We had some issues with the support forum attachments, I believe they are now resolved.

Can you tell me which transformation is not working?
Peter Jonson
Support Analist
Attachments:

Please Log in or Create an account to join the conversation.

SQL LookUp Queries 1 year 4 months ago #18125

  • trally
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 52
  • Thank you received: 0
Hi Peter
Apologies I ended up having to re-enter the original message and obviously left out the Transformer -
it is "Scan for Bondi V InterestTMems W Pics" which used the SQL LookUp as shown in the screen shots of the word doc

Regards

Please Log in or Create an account to join the conversation.

SQL LookUp Queries 1 year 4 months ago #18126

Hi Tral

The issue you reported was corrected in the latest release.
We also made In Place Replace Transformation Function More user-friendly.



Thank you for your feedback
Peter Jonson
Support Analist
Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 186 guests and one member online