Answered

Need to combine CSV files so one becomes the Header

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

We found an issue in QA; I need to add the first row (Row #1) of a CSV file to an already existing CSV file.

The first row looks something like this:
05, ,2021-01-25, ,BMECOL, ,750

How can I insert this as the first row to my already existing CSV file? It must be on the first row. I have googled until my fingers hurt :-). This is urgent to us. Thanks as always!
Mike Kiser

Categories:

Using flows

I have the same question (0)

All responses (17)

Answers (5)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

I’m not in front of my pc right now but if you get the file contents via get file and literally create a compose with the header, followed by a return line and the dynamic content of the get file - file contents, you can then save the compose back to the original file as the new content.

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey DamoBird365! Thanks so much; I am not sure how to do that. Could you please give more detail? I have been killing myself all weekend on how to do this. Thanks! Mike I have one csv (different number of columns) and a 2nd CSV that I was to merge with the 1st column beginning with 05 on the first row. I really appreciate your help...thanks! Mike KIser

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Im using my mobile but the same idea applies.

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

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

How are you getting on?

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello! Thanks for asking! I was put on an encryption task but back on this; I am getting ready to implement your solution; I wanted to get your opinion...I just got the other from our Microsoft Team here. What do you think about it working? My question was that I have to have one particular file appended to another and not which one comes first. I guess I can try them in serial instead of parellel. What are your thoughts @DamoBird365 . I love this forum; In other forum's I'm used to waiting days for a reply.
Thanks again!
Mike Kiser

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I don’t see why you cannot get them in parallel? You know which file is which surely as it is defined by each action.

I agree about this being a good community.

Damien

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello again @DamoBird365 ! I understand what you are saying now. So you are right..it shouldn't matter which of the 2 runs first....I'll be trying it tonight (our schedule is a killer lol)....thanks again! Will let you know how it goes.....Thanks! Mike

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good morning @DamoBird365 , it is looking close now, but for some reason it is putting a /r/n (an extra blank line) in between the items. Do you know how I can get those out? It is what is causing the space between the lines which our QA won't accept. Do you know of a quick way to remove the line space between the lines? And then I might be done :-).
Thank you for your continued help! I'm almost there!
Mike

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
You need to look back at the history. Is this already present in the original file(s) or are you seeing this only as a result of the merge?

Damien

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I meant to add this @DamoBird365

Was this reply helpful? Yes No