Joshua Barnett
- Total activity 9
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 3
Activity overview
Latest activity by Joshua Barnett-
Joshua Barnett created a post,
Custom SQL Import Job Error
I am seeing the following error when I enter my custom SQL "The SQL contains an illegal action or keyword: 'delete'". How do I use the word delete in my SQL filter. Do I need to wrap the text in so...
-
Joshua Barnett created a post,
Cron Pattern for Quarterly Run
I cannot find a custom cron pattern to run an import on a quarterly basis. The import runs would happen in Nov, Feb, May, and Aug. Any ideas?
-
Joshua Barnett commented,
This strategy should work. Thanks. The identifier and number should always be linked to the same person.
-
Joshua Barnett commented,
Below is an example. I need to join based on Customer Number or Customer Identifier to pull in the "data to be pulled in Join" column in the right table (left join). You can see sometime there is a...
-
Joshua Barnett created a post,
Join on Multiple Criteria with Or Statement
I am wondering if there is a way to join two datasets with one column or another column (ie. match on customer code or on custmer name). It seems that if you specify multiple criteria in the join i...