Insert and Update CSV data in postgresql, Clean & Transform Data using Pentaho Data Integration

[@sakthivelm5344]

Usefull information. Thanks 👍

[@bindupriya9046]

Hey hi, the content is too good, can you please upload some more videos on Pentaho, please🙏

[@gulziraizbassova8381]

Hello, sir! Thanks for useful video. I did all your steps, but i can not do it. Please, can you help me decide this problem. Table output.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Unexpected batch update error committing the database connection. 2021/07/17 16:42:14 - Table output.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException: 2021/07/17 16:42:14 - Table output.0 - Error updating batch 2021/07/17 16:42:14 - Table output.0 - Batch entry 0 INSERT INTO "public".Measurement_item_info (Item_code, Item_name, Unit_of_measurement, "Good(Blue)", "Normal(Green)", "Bad(Yellow)", "Very bad(Red)") VALUES ( 1.0, 'SO2', 'ppm', 0.02, 0.05, 0.15, 1.0) was aborted: ОШИБКА: отношение "public.measurement_item_info" не существует Position: 13 Call getNextException to see other errors in the batch. 2021/07/17 16:42:14 - Table output.0 - 2021/07/17 16:42:14 - Table output.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1436) 2021/07/17 16:42:14 - Table output.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1425) 2021/07/17 16:42:14 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:590) 2021/07/17 16:42:14 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97) 2021/07/17 16:42:14 - Table output.0 - at java.lang.Thread.run(Unknown Source) 2021/07/17 16:42:14 - Table output.0 - Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "public".Measurement_item_info (Item_code, Item_name, Unit_of_measurement, "Good(Blue)", "Normal(Green)", "Bad(Yellow)", "Very bad(Red)") VALUES ( 1.0, 'SO2', 'ppm', 0.02, 0.05, 0.15, 1.0) was aborted: ОШИБКА: отношение "public.measurement_item_info" не существует Position: 13 Call getNextException to see other errors in the batch. 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148) 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:824) 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1538) 2021/07/17 16:42:14 - Table output.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1412) 2021/07/17 16:42:14 - Table output.0 - ... 3 more 2021/07/17 16:42:14 - Table output.0 - Caused by: org.postgresql.util.PSQLException: ОШИБКА: отношение "public.measurement_item_info" не существует Position: 13 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) 2021/07/17 16:42:14 - Table output.0 - at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:821) 2021/07/17 16:42:14 - Table output.0 - ... 5 more 2021/07/17 16:42:14 - Table output.0 - Finished processing (I=0, O=0, R=6, W=0, U=0, E=1) 2021/07/17 16:42:14 - Spoon - The transformation has finished!! 2021/07/17 16:42:14 - demo - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Errors detected! 2021/07/17 16:42:14 - demo - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Errors detected! 2021/07/17 16:42:14 - demo - Transformation detected one or more steps with errors. 2021/07/17 16:42:14 - demo - Transformation is killing the other steps!

[@srinivasmadhuregurumurthi2919]

make a videos on scd

[@purnimachintala6721]

Hi do u provide support

[@mohammadqasim6027]

can i have your email id to write down quires .