How to extract 2 columns from a csv

[phil4]

I’m new to make. I have a htpps module to receive a csv from a server. I then want to extract 2 columns (not rows) from it and copy the columns to an existing excel document. ie so that each day I have 2 extra columns in my excel that have come from the daily file in the server . Please can someone help

[ponvaskon]

Hi @phil4

I would suggest this approach.

1. Set the ‘CSV contains headers’ to ‘No’ in the Parse CSV module.
   
   
2. Agreggate all results of the Parse CSV module into an array.
   
   
3. Add this array to an iterator module.
   
   
4. Add this filter after the iterator module; it will only extract the column headers of the CSV.
   
   

I attached the blueprint of this setup; you can import it to your Make scenario.
blueprint.json (7.2 KB)

[samliew]

Welcome to the Make community!

@phil4

extract 2 columns

You did not specify how you want the columns identified.

Did you want to extract entire columns by the column header values? If yes, Select columns from 2d array

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[phil4]

thanks I will try that although I wanted to append the data to a new sheet as 2 columns of data not as rows ie so that everytime I run it it willl create 2 new columns of data at the end of the new spreadsheet eg first time col a&b, 2nd time col c&d
Also as each column has 100s of entries I wondering how I’m goign to do this without using 100s of operations ??

[samliew]

I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you already have a scenario, or are currently building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[phil4]

yes i want the entire column. How do I extract that using the column header. I dont understand anything about 2d array and unfortunately the link doesnt help