Need to combine CSV files so one becomes the Header

[Anonymous]

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

[DamoBird365]

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

[Anonymous]

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

[DamoBird365 · Accepted solution]

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

[DamoBird365 · Accepted solution]

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

[Anonymous]

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

[DamoBird365]

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

[Anonymous]

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

[Anonymous]

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

[DamoBird365]

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

[Anonymous]

I meant to add this  @DamoBird365 

[DamoBird365]

Hi @Anonymous 

Your last solution looks a bit odd.  It's OK to get both blobs in parallel but then the update should be after both of these actions.  You had previously posted this order.

Damien

[Anonymous]

Hi @DamoBird365 , very sorry for the confusion...that one didn't work...I love the versioning on Logic Apps (ADF doesn't have it and I wish they did) this is the one that is correct but giving an extra /r/n between lines....any suggestions? If I could just remove one of the /r or /n, it might be correct..

Thanks again! MIke

[DamoBird365 · Accepted solution]

You can do that with a replace expression but ideally you want to find out why/where in the history.

If you create a compose and hit return, you can then use the replace on the string where the string to replace is the compose (i.e. the return line - by hitting return).  No need to encode/decode /r/n.

Damien

[Anonymous · Accepted solution]

Thanks again...I am trying to understand what you are suggesting....can you please explain a little further (I am an Azure Data Factory guy and have not done much Logic App, but the ADF can not do this type of thing that Logic Apps can do)...thanks so much! We are almost there...Mike

[DamoBird365 · Accepted solution]

Hi @Anonymous 

Did you sort it?  I am not sure why you would be getting return lines but you could experiment with the following:

Damien

[Anonymous]

Thanks so much @DamoBird365 ! Now I understand completely; I did locate yesterday that I have so many fields I am bringing back from the DB that it is causing it to do a line break. So I am going to see from the Users if there are any fields I can drop. Your solution on the returns should help me out immensely also. Again, I really appreciate your time and also again, I love this Community! It is better than any Azure Data Factory or any other Community that I am a member of!  Mike

[Anonymous]

BTW Your Blogs are very interesting!.....