give me the link

when i try to browse the filename, my browse button is not working. it's like I clicked it but it just won't show anything

Sir, I want to ask, why can't the browser (filename) in the input csv file be clicked

Link no longer works..?

Thank you very much for these videos!

Is there any way to do LEFT/RIGHT JOIN removing results maching A AND B? To show only items in A not available in B.

Hi i have huge records like 13lakh input to run.. The input is text file input... But even after serializing it is still throwing java heap error or software is stuck.. Any possible solutions?

i have more then 300.000 data and i table input group by step -> sort row. but the sort row process at the writing stage is very long

How could CSV placed on linux server be loaded ? please help

watched this after using your "Group By" tutorial to get my head around that (succesfully thanks) but one minor (very pedantic) thing, CSV is "Character Seperated Values" rather than "Comma Seperated Values" (although admittedly commas are the most common form of separation.

Do you have an updated link for Data to follow along in the examples on this Mini Course?

Thanks for the video.

Thanks for the video.

Is Kettle or Pentaho at all still relevant? Everything I see is years and years old.

Really liked your instructions, do you still have the courses of PDI? The website is off. I would like it.

De los mejores cursos de pentaho spoom paso a paso aqui: kzbin.info/www/bejne/pWisl2SXYsyer6s

thank you!!

I cannot get access to your website, this account has been suspended

Mr. Mark, thank you very much for the tutorial. I have gone throught all yours tutorials and would like to claim that you are very good in teaching. Probably event its your talant! Thank you for sharing knowleges!

link is not working redirecting to apps4875.yourbigwin9.live/2570436625/ page

I just wanted you to know that your URL might have been hijacked. I clicked on it and it said it need to install flash. It looked legit but when i t downloaded it was not flash and i did not install it. it did not take me to your URL and subsequently did not take me to your mini-course. then when i came back to click on your 2nd link which was supposed to take me to your website, instead i got a screen that said i was like the 5000th visitor or something and that i won something. I am not sure if the issue is with your links or my system. I have not seen any issues with my system recently as i am a data analyst and i help manage sensitive health care data so i have to be very careful about what installs on my system. Regardless, i thought i would let you know just in case. I decided to type in your website and am able to take your mini course that way.

And what would be the use of "Data Grid"?

sir how to connect penatho to solr plz tell me

Very good introduction in detail. Thanks a lot.

Hello sir , Please help me to solve this problem... {"product": [ {"prdid":101,"prdname":"p1","price":200}, {"prdid":102,"prdname":"p2","price":250}, {"prdid":103,"prdname":"p3","price":300} ] } My problem is I need to update all price columns values is 500 in Kettel or Mysql as well ...and o/p should be at below format... ------ {"product": [ {"prdid":101,"prdname":"p1","price":500}, {"prdid":102,"prdname":"p2","price":500}, {"prdid":103,"prdname":"p3","price":500} ] } please help ,me solve this issues....

is it also possible to do a count function?

Thanks for this video. It is very helpful. Also I want to learn how to add 2 or more excel files to one excel file ot merge them. Could you help me about it?

Thank you sir

Thank you! Clear and to the point.

I have a question to ask.I have two different tables and i want to join them but i dont have primary key to match but they match partially .if i get ur email id i can clearly explain you please help me

Thanks for all. As a sugestion "You had to mentioned the need to use SORT BY STEP before MERGE JOIN STEP".

Thank You d(˘◡˘)b

Thanks for posting video on Pentaho. Speak to GrayMatter’s Pentaho experts to know more about the latest #HitachiVantara #Pentaho 8.0! Register now pentaho.graymatter.co.in/pentaho-demo-registration

Great tutorial. Really helped me a lot

can you give you email address to contact,I am a new user to Pentaho and I have relatively advanced issues to ask from you. Thanks and much appreciate your effort. :)

explained In-detail, thanks for sharing knowledge

No need, the problem was sorting the parameter before merging

I am working with a merge in a inner way and the results are lower tha it should be. What can it be?

Respected Mark, I am sorry i need help. I tried to connect to SQL Server database through PID. I downloaded the jdbc driver for sql-server from microsoft and unzipped in path "C:\Pentaho\design-tools\data-integration\libswt\win64\sqljdbc_6.0". After do that still not able to connect to sql-server from any step. Even i downloaded the jtds from source forge and unzipped and copied the entire directory contents in path "C:\Pentaho\jdbc-distribution ". For jtds in copied the entire winrar file into path "C:\Pentaho\design-tools\data-integration\Data Service JDBC Driver". I am not sure what to do here. Kindly help me. Your video explanation is very good. Error information is pasted : Error connecting to database [ssconn] :org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed. net.sourceforge.jtds.jdbc.Driver org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed. net.sourceforge.jtds.jdbc.Driver at org.pentaho.di.core.database.Database.normalConnect(Database.java:472) at org.pentaho.di.core.database.Database.connect(Database.java:370) at org.pentaho.di.core.database.Database.connect(Database.java:341) at org.pentaho.di.core.database.Database.connect(Database.java:331) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2795) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:110) at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157) at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:147) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:131) at org.pentaho.di.ui.trans.step.BaseStepDialog$3.widgetSelected(BaseStepDialog.java:709) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:436) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:127) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8789) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3179) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:775) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1359) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7990) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9290) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:685) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed. net.sourceforge.jtds.jdbc.Driver at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:515) at org.pentaho.di.core.database.Database.normalConnect(Database.java:456) ... 44 more Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490) ... 45 more Please help

Very clear explanation. Thank you very much!

Thanks Can u please provide Aggregate step video

Thanks. Very Useful!

Thank you !!! I never imagined that needs a "Sort Row" to run

Great job. Thanks a lot.

Nice

can you show how to delete filenames from result using wildcard. please

Thank You Very Much. Very Useful Tutorial.

Thanks for share your skills.

Dear Sir, Good to see your web session. It's very informative. Do i have any possibility 4 tables data put into one single table using Merge jobs? Can you please advise? Regards, Suresh

Clear and simple - this is how I like it!