This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
Damone
New Contributor
since ‎09-27-2018
‎07-25-2023

User Statistics

  • 10 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

How to Create a SQL Server Connected Lookup

06-15-2022
I need to mimic Informatica’s simple connected lookup process. I want to look for a record on a target table and if it exists, update it, otherwise insert it. I have tried to use the Lookup Snap, but I haven’t been able to make it work for me. Does...

Null Values Not Written to Table

06-09-2022
My Oracle input is address information similar to: STREET: 123 MAIN STREET CITY: ANYTOWN STATE: ANYSTATE ZIP: 12345 COUNTRY: USA STREET: null CITY: OTHERTOWN STATE: OTHERSTATE ZIP: 54321 COUNTRY: CAN STREET: null CITY: OTHERTOWN STATE: null ZIP: null...

Convert Date.now() to the Day of the Week Name

03-08-2021
This may have been asked before, but I can’t find a solution. I need to extract the weekday name from the current date. In other words, today is March 8. I need ‘Monday’. Date.now().getDay() returns the number 1.