Expand my Community achievements bar.

Applications for the Community Advisor Program Class of 2025 are NOW OPEN – Apply Today!

Auto apply 400 rows for all the breakdowns in CJA

Avatar

Level 1

Hi Everyone

I have a Report in CJA 

Day                                               Events
Day 17
      Asset_id  Rows 400 
         1 A_id
         2 B_ID
         3 C_ID
         4 D_ID
         5 E_ID
Day 18 400 rows (but showing only 5)
        Asset ID
Day 19 400 rows (but showing only 5)
      Asset ID
Day 20 400 rows (but showing only 5)
... so on and forth till Day 200
There is Asset_id in all Days

The Question is I have to keep all the rows to maximum to 400 for Asset_ID
If I will do it manually like increasing rows to 400, It will take a lot if time 
Is there any way ? i.e. all the rows should show 400 rows by itself



Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Level 1

The reason I need all 400 rows for all breakdown is 
I want to send the csv file and When I click on Send File and then send it as csv THEN it only shows the rows displayed in the report

Avatar

Adobe Champion

Hi @RajatAr ,

I'm not aware of any way to have the default setting in Workspace return 400 rows every time, but have you tried using Full Table Export for this? It's easier to set up than you might think, and you can then get a CSV file that contains all the rows of data, and rather than breakdowns, you'll have columns for each of your additional dimensions. The only caveat is that when viewing in Excel, you have to be conscious of the total number of rows in the resulting file  (should be less than 1.048 million rows). 

 

I've had success setting up an AEP Data Landing Zone for storing my exports, and then using the Microsoft Azure Storage app to retrieve them.

 

Avatar

Community Advisor and Adobe Champion

While the process is a bit manual, if you create your table with "breakdown by position" selected:

Jennifer_Dungan_0-1740195308826.png

 

And then you choose "400" as your breakdown on each row, as new Days roll in, they should maintain the 400 rows breakdown.

 

I don't know of anyway to do this in one step, but once you have set this up the first time, you shouldn't have to continue to chose those breakdowns each week or month, etc that you are pulling the report.

 

Avatar

Level 2

@RajatAr  I don't think so there is any out of the box solution, Because keep that in mind if we are doing this for many elements in the freeform table you will not able to read the data, and your report is going to become very slow, so keep all that in mind. My suggestion is that don't use this way