I want to update the obtained csv file to only the desired values and save it

Help me Build my Workflow
1

I want to create the following workflow, but I’m not sure how to proceed from step 3. Please help.

  1. Search Google Drive for .csv files containing the name “test_”
  2. Download the found CSV files
  3. Convert CSV to JSON
  4. Extract only the “Product URL” column and add “https://test” to the beginning of the URL
  5. Save as test_save_date.csv
2

Hello @junx,

After Download the CSV file (step 2):

  1. Use the Extract from File node (choose CSV), This will output each row as its own item.
  2. Add a Set node to keep only the Product URL field, using this expression to concatenate your domain {{ "https://test" + $json["Product URL"] }}
  3. Use the Convert to File node to turn the modified JSON back into a CSV (with just the updated Product URL) and save it as csv.

Here is an example to help:

3

It doesn’t work.
I’ve attached the workflow I created and test.csv.
Is it possible to extract only the “Product URL” column and add “https://test” to the beginning of the URL?
I would like you to create a workflow for me.csv file

workflow json file

1 Like
4

Hi, what do you mean by it doesn’t work?!

By the way, I just created it again with your sample CSV file,
Please take a look:

the outout:

image
image309×441 4.35 KB

5

This may be because the csv file is large, but it won’t load properly…
The contents of the csv file are not displayed as shown in the attachment.

image
image1281×849 39.7 KB

6

Can you please just copy and paste and run this exact workflow:

image
image1214×287 30.5 KB

This should output a csv file like this

image
image309×441 4.35 KB

7

It worked fine with the test CSV file!!
However, the production CSV file has about 7,000 rows and 20 columns, so that may be the cause.
Thank you for your help.

1 Like
8

Hi, Please i have a related question on this subject….my CSV input file has a preceding row like a banner before the main header fields. How can i remove this banner row (and some empty preceeding spaces) before the actual header rows in the csv file. Right now the banner row is distorting the output of my csv conversion and i would like to get rid of it through my work flow. I have uploaded the sample file. All i want to do is to downloadd the file from google drive, remove the banner rows and the first 3 columns of the actual header rows and upload it back to google drive. Any assistance or insight would be really really appreciated

csv file conversion
csv file conversion548×300 69.1 KB

9

Hi @cassado_flick

Suppose you don’t want the first 3 rows in the CSV file:

image
image676×308 14.2 KB

In the “Extract from File” node, there’s an option called “Starting Line”
You can set it to 4 like this:

image
image417×493 17.6 KB

After that, use “Convert to File” to create a new CSV file, which you can then upload or use however you like.

Here’s an example:

10

thank you…that really worked nicely

1 Like