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

TOPIC: SQL LookUp Queries

SQL LookUp Queries 11 months 4 weeks 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 11 months 4 weeks 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 11 months 4 weeks 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 11 months 4 weeks 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 195 guests and 2 members online