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
解決済! 解決策の投稿を見る。
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.
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
Hello @joannasokolowska ,
Lets start with this and see where it leads.
Have a look and it will give you an idea.
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?
Maybe have 2 first rows with the same column names?
Do you know how to do this? 🙂
A
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.
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)
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.
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?