You’re offline. This is a read only version of the page.
11
Hello All,
I am new to this so finding it difficult. I have the basics figured out but don't know how to put it together.
I get a CSV report everyday and I want to take all the rows and insert them into the table in a postgres DB in GCP. I have created a table from csv file, I have connection to the table is working but I am not able to figure out how to load individual row of CSV data table to a row in postgres table.
Please ignore "Create File" as that is just to keep a copy on one drive.
Seems like Insert Row requires data, but how do I extract data for individual column from the CSV table row?
Hi @Moonking ，
The CSV file is a comma-separated values file
Line breaks separate rows and commas separate columns
Here is a test for your reference:
Here is CSV file:
Here is test:
Put data lines into an array by line breaks, then turning [,] into [; ]
Note:
Parse JSON needs to get the schema:
1.You need to test it first to get Select's Body
2.Put Select's Body in
Finally
Here is result :
You can load a single row from a CSV data table into a row in a postgres table.
Here is a link for you reference:
Parse CSV File Using Power Automate (c-sharpcorner.com)
Best Regards
Cheng Feng
Share
Report
All responses (
Answers (
