Adobe Report Builder: how to avoid empty rows in file format CSV | Community
Skip to main content
J
JeBolan
June 16, 2017
Solved

Adobe Report Builder: how to avoid empty rows in file format CSV

  • June 16, 2017
  • 9 replies
  • 7090 views

Hello,


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:

Question:

How can I avoid to get the ",,,,,,,,,,," lines in mine .csv file?

Thanks for helping me in advance.

Greetings,
Jeroen Boland

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Hyder_Ziaee

    Basically, try to recreate the table using pivot table functionality.

    1. Select the output report builder table 
    2. Go to Insert tab and click Pivot Table
    3. Select all the columns in the same order as required
    4. Go to Design tab (will show up after selecting anywhere on the pivot table)
      • Change Subtotals to "Do not show subtotals"
      • Change Grand Totals to "Off for Row and Columns"
      • Change Report Layout to "Show in Tabular Form"
    5. The next part is add a filter to remove blank values in the first row
    6. The last step is to keep the pivot table sheet as the first sheet.

    Schedule this workbook

    Example table:

    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

    9 replies

    Hyder_Ziaee
    Adobe Employee
    Hyder_ZiaeeAdobe Employee
    Adobe Employee
    June 18, 2017

    Hi Jeroen,

    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.

    -Hyder

    J
    JeBolanAuthor
    June 20, 2017

    Hi Hyder,

    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?

    Regards,

    Jeroen

    Hyder_Ziaee
    Adobe Employee
    Hyder_ZiaeeAdobe Employee
    Adobe Employee
    July 4, 2017

    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!

    jamesc82861453
    jamesc82861453
    September 25, 2018

    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

    jamesc82861453
    jamesc82861453
    September 25, 2018

    Hi Jeroen,

    Did you find the workaround to the extra empty rows? I tried pivot table option, but did not work for me. Could you please help

    Hyder_Ziaee
    Adobe Employee
    Hyder_ZiaeeAdobe EmployeeAccepted solution
    Adobe Employee
    September 26, 2018

    Basically, try to recreate the table using pivot table functionality.

    1. Select the output report builder table 
    2. Go to Insert tab and click Pivot Table
    3. Select all the columns in the same order as required
    4. Go to Design tab (will show up after selecting anywhere on the pivot table)
      • Change Subtotals to "Do not show subtotals"
      • Change Grand Totals to "Off for Row and Columns"
      • Change Report Layout to "Show in Tabular Form"
    5. The next part is add a filter to remove blank values in the first row
    6. The last step is to keep the pivot table sheet as the first sheet.

    Schedule this workbook

    Example table:

    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

      jamesc82861453
      jamesc82861453
      October 11, 2018

      Thank You

      jamesc82861453
      jamesc82861453
      October 18, 2018

      Hi Hyderziaee,

      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 ?

      Hyder_Ziaee
      Adobe Employee
      Hyder_ZiaeeAdobe Employee
      Adobe Employee
      October 22, 2018

      Hi James.

      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.

      Terms & ConditionsAccessibility statement

      Loading footer...