Profile

arin gregoriades

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 3 of 3 total

Can I denormalize rows with the same ID to new colums?

Posted By arin gregoriades 09-08-2021 19:39
Found In Community: Pentaho \ view thread
Im getting data from JSON like this The punchtype is either ID or OD. For each Punchdate there can be multiple ID and OD punchtimes. I need to have a table that has rows, eebadge, punchdate, ID_1, ID_2, Etc...   This is what I have but Im getting errors. Any ideas?

Update/Insert with and/or

Posted By arin gregoriades 08-30-2021 16:56
Found In Community: Pentaho \ view thread
I have a database with some missing information. I have a stream of data coming in from Pentaho. Im trying to update the info based on the stream.   The table looks like   EMP_ID, Clock_IN, Clock_Out, Date,UUID   Some rows will have the Emp_ID, Clock_Out, and Date but be missing the Clock_In. Some rows ...

How do I get many rows from one HTTP post?

Posted By arin gregoriades 07-29-2021 21:29
Found In Community: Pentaho \ view thread
I have a transformation that posts XML to a web service and then records the XML result in a field. I feed that field into the XML input stream. The XML input stream needs one row per element but I dont want to do the HTTP post 50 times each time. How can I get the input stream to add as many rows as ...