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

preview_player
Показать описание
#insert #update #csv #data #postgresql #clean #transform #pentaho #integration #data #science
Insert and Update CSV data in postgresql, Clean & Transform Data using Pentaho Data Integration
  1. Data & Computer Science
Рекомендации по теме
Insert and Update 0:18:02

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

Insert, Delete and 0:20:50

Insert, Delete and Update on CSV file in Power Automate

Import CSV file 0:06:33

Import CSV file into existing Table Sql server

122. Insert and 0:14:40

122. Insert and Update Records from CSV to SQL Server with Azure Data Factory (ADF)

Insert and Update 0:04:01

Insert and Update Attribute Blocks from csv Excel File

Opening .CSV Files 0:01:39

Opening .CSV Files with Excel - Quick Tip on Delimited Text Files

How to Import 0:03:22

How to Import CSV File Into Excel

Import CSV file 0:04:04

Import CSV file to SQL Server Database

GenAI & LLMs 1:17:12

GenAI & LLMs | Video 10 | Langchain Agents and Toolkits | Venkat Reddy AI Classes

MYSQL Tutorial: Efficiently 0:08:41

MYSQL Tutorial: Efficiently Importing Large CSV Files into MySQL Database with LOAD DATA INFILE

Importing CSV data 0:06:25

Importing CSV data inside power BI Desktop

Update CSV With 0:06:20

Update CSV With Streamlit Form

95 How to 0:04:13

95 How to import a csv file into SQL Server using bulk insert SQL query

Upload A CSV 0:05:44

Upload A CSV File (Or Any Data File) To SQLite Using Python

11 Import CSV 0:04:28

11 Import CSV File To PostgreSQL

How to IMPORT 0:05:04

How to IMPORT Excel file (CSV) to MySQL Workbench.

How to open 0:02:00

How to open CSV file correctly in different columns

Sending CSV Data 0:01:21

Sending CSV Data To Datasets (Power Automate)

Python - Adding/Appending 0:03:38

Python - Adding/Appending Data to CSV Files

How to Import 0:00:18

How to Import CSV in Tableau Public

Easily import CSV 0:03:47

Easily import CSV data using SSIS

Import CSV to 0:07:35

Import CSV to SQL Server using Azure Data Studio

06 How to 0:03:53

06 How to import a csv file into MySql workbench

How to pull 0:08:08

How to pull data from a CSV file in Python

Комментарии
Автор

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

bindupriya
Автор

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) :
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 (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: ОШИБКА: отношение не существует
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
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
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: Batch entry 0 INSERT INTO (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: ОШИБКА: отношение не существует
Position: 13 Call getNextException to see other errors in the batch.
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - ... 3 more
2021/07/17 16:42:14 - Table output.0 - Caused by: ОШИБКА: отношение не существует
Position: 13
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
2021/07/17 16:42:14 - Table output.0 - at
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!

gulziraizbassova
Автор

can i have your email id to write down quires .

mohammadqasim