Activity Stream - Pentaho Community Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums

Today, 12:06 PM

gutlez replied to a thread Regex to retrieve part of string in Pentaho Data Integration [Kettle]

If your string is a well-known date format, why not convert it from String to a date? You can then do all the useful functions on that including...

2 replies | 33 view(s)

Today, 07:46 AM

Sparkles replied to a thread Regex to retrieve part of string in Pentaho Data Integration [Kettle]

Yes you can have a regex for that purpose. But you would have better luck trying a regex forum, as this is not specific to kettle. Regex could...

2 replies | 33 view(s)

Today, 07:18 AM

Ajinkya started a thread Regex to retrieve part of string in Pentaho Data Integration [Kettle]

Hi all, I want to retrieve 25 from following string. For example: Sunday, 25 March, 01:00 The format of above string is fixed. Can I get it...

2 replies | 33 view(s)

Yesterday, 06:08 AM

Sparkles replied to a thread Multiple Kitchen log entries (console) in Pentaho Data Integration [Kettle]

Logging in Kettle is a mystery to me. I only write to log file manually, and set all log levels to "Error only". That way I get full log in case...

1 replies | 49 view(s)

09-18-2018, 12:23 PM

gutlez replied to a thread Select value metadata change gives wrong result. in Pentaho Data Integration [Kettle]

From the Java Documentation (https://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html ): For parsing with the abbreviated...

3 replies | 72 view(s)

09-18-2018, 11:25 AM

vinodThakur replied to a thread Select value metadata change gives wrong result. in Pentaho Data Integration [Kettle]

Than how this step is converting eg 02/02/36 to 02/02/2036 which is correct and not 02/02/1936.

3 replies | 72 view(s)

09-18-2018, 10:54 AM

gutlez replied to a thread IMPORTANT - Pass Date range filter in Saiku Query in Mondrian [Pentaho Analysis Services]

You might have better luck asking Saiku questions on one of the Saiku community paths: https://community.meteorite.bi/

1 replies | 40 view(s)

09-18-2018, 10:47 AM

cbsantos started a thread Multiple Kitchen log entries (console) in Pentaho Data Integration [Kettle]

Hi, I'm trying to better configure my console log4j output adding a tag to that. I altered the file...

1 replies | 49 view(s)

09-18-2018, 06:48 AM

Neelam started a thread IMPORTANT - Pass Date range filter in Saiku Query in Mondrian [Pentaho Analysis Services]

Hi, How to pass date range filter to Saiku dashboard from saiku UI, without swithing to mdx mode ( as I have to keep UI for further dashboards...

1 replies | 40 view(s)

09-17-2018, 02:49 PM

gutlez replied to a thread trying to avoid duplicate code in UDJC in Pentaho Data Integration [Kettle]

Since a plug-in is Java code, the plug-in can contain the method (thus allowing it to be reused), and then call the appropriate UDJC. Basically,...

4 replies | 114 view(s)

09-17-2018, 03:25 AM

Sparkles replied to a thread Select value metadata change gives wrong result. in Pentaho Data Integration [Kettle]

How can a machine know that 1948 is wrong? If your input data doesn't contain enough information to understand what the year is, you should modify...

3 replies | 72 view(s)

09-17-2018, 03:15 AM

vinodThakur started a thread Select value metadata change gives wrong result. in Pentaho Data Integration [Kettle]

i have input date like dd/mm/yy e.g 02/02/48 while im converting this to dd/mm/yyyy format using select value step it is giving 02/02/1948 which is...

3 replies | 72 view(s)

09-17-2018, 02:32 AM

Sparkles replied to a thread trying to avoid duplicate code in UDJC in Pentaho Data Integration [Kettle]

How would that help to share code between UDJC steps?

4 replies | 114 view(s)

09-17-2018, 02:04 AM

lavanya578 started a thread Unable To Read The Data From Hive in BI Platform

Hi , Am trying to read the data from hive db using PDI 8.1 by applying join from tables residing in hive itself. Getting below error. ...

0 replies | 45 view(s)

09-16-2018, 01:15 PM

Neelam started a thread Pass parameter via url to mdx query in saiku query. in Mondrian [Pentaho Analysis Services]

Hi, Can someone pls provide me link for passing parameters to saiku query to ,have a row level filter. I have tried may approaches still no...

0 replies | 51 view(s)

09-15-2018, 05:24 AM

Gosforth started a thread Any chance for working step "ElasticSearch Bulk Insert"? in Pentaho Data Integration [Kettle]

Elastic has Logstash to load data into Elasticsearch. Problem is that this piece of software is really bad quality; actually it does not work with...

0 replies | 65 view(s)

09-14-2018, 11:30 AM

thiagofred replied to a thread Split data from irregular CSV in Pentaho Data Integration [Kettle]

Thanks for help Ana. After I transform comma in |, I used a Modified Java Script step to select Number values where like a date, then I moved the...

6 replies | 237 view(s)

09-14-2018, 11:24 AM

gutlez replied to a thread trying to avoid duplicate code in UDJC in Pentaho Data Integration [Kettle]

You could develop a plug-in...

4 replies | 114 view(s)

09-14-2018, 10:12 AM

codek replied to a thread How to work with encrypted user passwords? in BI Platform

For anyone who comes across this, detailed blog here: https://dankeeley.wordpress.com/2018/09/13/pentaho-security-full-jdbc-passwords-with-salts/

11 replies | 8819 view(s)

09-14-2018, 03:10 AM

Sparkles replied to a thread trying to avoid duplicate code in UDJC in Pentaho Data Integration [Kettle]

Not that I know of. It would most likely need to jars as you mention. Maybe you could add the kettle core library to the external jar? Or you...

4 replies | 114 view(s)

09-13-2018, 08:57 PM

eych started a thread trying to avoid duplicate code in UDJC in Pentaho Data Integration [Kettle]

I have one Java method that I use in many UDJC steps among multiple transformations. The method involves accessing parent/root jobs and...

4 replies | 114 view(s)

09-13-2018, 07:30 AM

Gosforth replied to a thread Can you recommend some trick to create MySQL table to insert data from input? in Pentaho Data Integration [Kettle]

This is what I needed. Have a great day!

2 replies | 90 view(s)

09-13-2018, 07:18 AM

johanhammink replied to a thread Can you recommend some trick to create MySQL table to insert data from input? in Pentaho Data Integration [Kettle]

When push button "SQL" in table output, Update or Insert / Update step you get create statement when table doesn't exist

2 replies | 90 view(s)

09-13-2018, 05:54 AM

Gosforth started a thread Can you recommend some trick to create MySQL table to insert data from input? in Pentaho Data Integration [Kettle]

Hello there, Sometimes it takes time to manually create MySQL table to insert data from some input (if lot of fields). Maybe there is some trick...

2 replies | 90 view(s)

09-13-2018, 05:39 AM

Gosforth replied to a thread Do we have some step to convert AD date into yyyy-MM-dd? in Pentaho Data Integration [Kettle]

To my surprise it works ;-) Thank you! I have such 'dates' in text file so automatic conversion does not take place.

2 replies | 144 view(s)

09-12-2018, 12:59 PM

gutlez replied to a thread Do we have some step to convert AD date into yyyy-MM-dd? in Pentaho Data Integration [Kettle]

42390 isn't an AD date. It's an Excel date. You can do it with calculator, by adding the number of days to Dec 30, 1899.... With issues. In...

2 replies | 144 view(s)

09-12-2018, 11:35 AM

Gosforth started a thread Do we have some step to convert AD date into yyyy-MM-dd? in Pentaho Data Integration [Kettle]

I have dates as numbers (for instance 42390). I see this post can be solution:...

2 replies | 144 view(s)

09-12-2018, 05:10 AM

theja replied to a thread Filter Component - search on server side in Community Tools - CTools

Hello, I've the same problem. It seems that problem is in 7.1 and 8.1 versions too. Do you have any solution? Thanks Tibor

1 replies | 334 view(s)