Add another row with merged column names/or empty row

[joannasokolowska]

Hey,

I need your advice regarding below case. 

1. This is what I have in the output excel file

2. This is what I would like to have in the output file (merged rows above column names ) or have the first row empty so other system can start uploading data from exact row number

Best,

Asia

[ImadZidan]

Hello @joannasokolowska ,

It is easier to output an empty row. I am not sure merged cells is possible.

How will the output look like in that case

Empty row

header

Data

Or ?

Please let us know.

[joannasokolowska]

hey,

Thank you for the quick reply! 

Yes, let's try as you suggested:

empty row

column titles

data

Could you please let me know how to add empty row ? 

Best,

Asia

[ImadZidan]

Hello @joannasokolowska ,

Lets start with this and see where it leads.

Have a look and it will give you an idea.

[joannasokolowska]

Hey,

I tried this but I realised that at the end of the workflow I need to generate many files based on column names (see below change entire file path) 

If I add empty row then this will not work...any idea how to solve this? 

[joannasokolowska]

Maybe have 2 first rows with the same column names? 

Do you know how to do this? 🙂 

A

[ImadZidan]

@joannasokolowska ,

We can do this no problems. It is sometimes difficult if we do not have the file.

So, you will create a file for every column or ?.

Please give us little more insight if possible.

[joannasokolowska]

Hey,

sure! please see the sample workflow attached. I need to add one more row above column titles. It could be duplicate row with column names. 

I just need to have one more row above column names so it can be used properly by the other system and this structure should be applied in every output file (output file is based on the course name) 

[ImadZidan]

Hello @joannasokolowska ,

I have amended the first workflow to include the file path for the null record and the label rows.

See if that works. If not, come back, I have another idea.

change the file path as I have changed it to mine.

[joannasokolowska]

Hey,

When I add more data to the input file and add output file I receive an error:

Do you know how to fix this?