Create CSV file from an Excel file

[evaristo]

Hello all,

I need to create a CSV file from an Excel file and the ideia is to use the WHEN A FILE IS CREATED IN A FOLDER trigger.

I am able to list the rows present at the table that I want to use as input, and filter the query.

The problem is to create the CSV file with the columns in a certain order and without header.

I have created the following flow:

With the following details:

The problem is that my flow is producing 3 files instead of one (one per each row), and the columns I define at the CREATE CSV TABLE are all together at the same column:

How can I create only one file, with the output spread by the different columns, and without the header (that is an extra I know)...

Sorry my rookie request but this is all new to me...

Thanks in advance!

[DamoBird365 · Accepted solution]

Hi @evaristo 

Two ways to achieve the same thing.  First, drop the apply to each.  You are looking to get the data from the values dynamic content.

You can use a select with a concat to create a string and then compose to join the select array with a return line.

OR You can use the create CSV table action, split the csv by a return line to create an array, drop the first object and then join the array back to a string using a return.

Note the compose called return, is literally a compose action with a return line, i.e. hit your keboard return once.

Maybe there is a simpler way, but I couldn't think of a way to skip the first line without it being an array.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

[evaristo]

Hello @DamoBird365 ,

thank you for your prompt reply! 

I tried to follow your steps but when I try to create the CREATE CSV TABLE step, I can't see the columns to select. Therefore I tried the 1st approach (or at least I think you are providing 2 different approaches):

My output seems perfect:

Without header and I only need to separate it by columns (using comma as delimiter).

However when I try to do it I get the following error:

What I am doing is the following (as you describe in your explanation):

Bu I also tried the following but I get the same error:

But I keep gettting the same error:

Can you help me understand what am I doing wrong? 

Many thanks for you help!

[DamoBird365 · Accepted solution]

Hi @evaristo 

I don't understand what you are doing with Compose2?  You have created a CSV without a header in the compose join, what is the purpose of trying to split?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

[evaristo]

Basically I need to convert the COMPOSE JOIN from this:

into this:

I guess I misunderstood your instructions above... 😞

How can I split each row of the COMPOSE JOIN into columns using the comma delimiter?

[DamoBird365]

Hi @evaristo 

When you open a CSV in excel, it will split the columns by the comma delimiter, however you might need to use the text to columns feature:

If you are looking for an excel file, xlsx, then you would need a different solution. 

You can populate an excel file using a table and excel action (add row) or write an excel office script.

Here's a video for you to watch -> https://youtu.be/Q7GLQnvJJF0

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉