Search Options
Skip to main content (Press Enter).
Sign In
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Communities
General Discussion
My Communities
Explore All Communities
Products
Solutions
Services
Developers
Champions Corner
Customer Stories
Insights
Customer Advocacy Program
Badge Challenges
Resources
Resource Library
Hitachi University
Product Documentation
Product Downloads
Partners Portal
How To
Get Started
Earn Points and Badges
FAQs
Start a Discussion
Profile
My Contributions
List of Contributions
Profile
Brandon Patterson
Shaker Regional School District
Contact Details
Shaker Regional School District
×
Enter Password
Enter Password
Confirm Password
Brandon Patterson
Shaker Regional School District
Profile
Connections
Contacts
Contributions
Badges
List of Contributions
My Content
1 to 8 of 8 total
search criteria =
ALL
RE: Is it possible to invoke REST API from Penatho?
Posted By
Brandon Patterson
03-15-2022 07:44
Found In
Egroup:
Pentaho
\
view thread
Hello, Yes it is possible. The way I have mine working is to us a generate rows step containing the URL, Authorization, accept and content type strings, I then feed those to the rest step, that returns a JSON response where I use a JSON step to parse the data into separate fields that I can format ...
RE: Trying to create a counter for unique number incremented by 1
Posted By
Brandon Patterson
09-19-2019 19:32
Found In
Community:
Pentaho
\
view thread
I have figured it out! one of the options in the table output step is return unique ID. So I pass the data to the Table output step, write something like their name or whatever to the Name column and Mysql auto increments the ID column, I then select that return Unique ID and pass that along to a formula ...
RE: Trying to create a counter for unique number incremented by 1
Posted By
Brandon Patterson
09-19-2019 17:22
Found In
Community:
Pentaho
\
view thread
SO for my instance maybe I am thinking of it backwards. We create email accounts with a users initials and then a 5 digit ID. If I could get it to work in this manor I would have to write the initials to the database first so that the sequence would assign its ID and then re-query the database to pull ...
RE: Trying to create a counter for unique number incremented by 1
Posted By
Brandon Patterson
09-19-2019 16:59
Found In
Community:
Pentaho
\
view thread
I think we are mis-understanding each other :), I What I am trying to do is use the add sequence step so that on Monday Susies info comes along to create an account with 50219 as an ID and then on Thursday Tommys info comes down the line to create his account with 50220, So basically I want it to query ...
RE: Trying to create a counter for unique number incremented by 1
Posted By
Brandon Patterson
09-19-2019 16:02
Found In
Community:
Pentaho
\
view thread
Thanks Ana, I am not super familiar with the add sequence. Can you give me an example of using a MySQL database to generate the ID? I created a Schema and Set the auto_increment attribute but when I go to query that with the add sequence I cant figure out what the sequence name is that the step is looking ...
Trying to create a counter for unique number incremented by 1
Posted By
Brandon Patterson
09-18-2019 15:22
Found In
Community:
Pentaho
\
view thread
Is there any way to use a counter to add a unique number to an output. I am trying to use Kettle to create some unique IDs for user accounts so I need a way to have a starting number, and every time it runs increment that number by one and never use any numbers over again. I am not sure of the best ...
RE: Email step in transformation Mail Destination Empty
Posted By
Brandon Patterson
09-05-2019 18:47
Found In
Community:
Pentaho
\
view thread
I was able to figure it out. I think part of the problem was that the data grid step I was using to provide my mail details only provides the details for one line. And each line is a separate email with the Mail step it was only providing an address to the first line. I changed from Datagrid to add constants ...
Email step in transformation Mail Destination Empty
Posted By
Brandon Patterson
08-28-2019 17:25
Found In
Community:
Pentaho
\
view thread
I am having trouble with a mail step within a transformation. I have configured all of the email fields and the email actually sends just find but Spoon throws an exception saying the Mail Destination empty, This is connected with a gmail gmail account for auth. Here is the actual error text. 2019/08/28 ...
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic