I have build a report with Adobe Report builder and use as filter "Top100"
The result varies from 1 to 100 rows.
In the data sheet I have in every row a formula's.
When I now schedule this report and choose .csv as file format, I got a file which looks like:
How can I avoid to get the ",,,,,,,,,,," lines in mine .csv file?
Thanks for helping me in advance.
Basically, try to recreate the table using pivot table functionality.
Schedule this workbook
Pivot table created:
Change in Subtotals, Design and Layout:
After making the changes:
If you want, you can remove/update the formatting, but should not matter since you will be getting a CSV
You could try creating a simple request and pivot table and see what happens. I am not sure what could be wrong here.
Try scheduling in XSLX and check if the pivot and the request table are updating.
The above solution did work and help. So first sheet is pivot table sheet in excel and 2nd is the normal one. I schedule daily report sending to FTP from 1st sheet. Now the problem is, everyday same day data is going. I did schedule the report but everyday it should go different data but it is going for same day data everyday.
Before pivot table option, it was going different files everyday but with empty rows. Now I implemented pivot option to get rid of empty rows then same day data is going to FTP server. Can you please help in what mistake I might be doing ?
Hi, I am also having same problem of extra empty rows. Could you please explain the steps in detail about "creating a pivot table and form the exact same table through it". I tired but did not work. In case, I might be doing wrong. Thanks
Totally forgot about this.
I tested, this and yes, it is sending out as you have mentioned.
The workaround I found was to create a pivot table and form the exact same table through it. Keep this as the first tab in the workbook and schedule this as a CSV.
Worked for me!
For the "Row Labels" I have the Top 1-1000 because I don't know how many External Promotions there are.
For each External Promotions I want to know Click Through and several other Metrics. I can't run them in 1 requests, because the Metrics have different segments for selection.
To get the data in an .CSV file I have created one sheet where I put all the data together for each External Promotions.
Therefor I have a sheet with up to 1.000 lines with all kind of formulas to get the data together.
Because there are not always 1.000 External Promotions there are line with a formula that create a blank in the cell
So from line 823 there are only blanks in the cell and that creats the empty lines in the .CSV file.
I think I can't use a Macro, because I want to Schedule the report and run in daily without opening the report.
Do you have any idea how to solve the empty lines on the bottom?
How many dimensions and metrics do you have here? I am guessing there should not be any rows which are completely blank. May need to look at it more deeply to understand what is happening.
However, there are ways to remove rows where a particular dimension doesn't have a value.