How to add multiple rows automatically in a table based on one column (drop down list) values?

Manjunatha K R_2vbq40

Hi,
My requirement table created in a confluence page as below column headers and sample rows as below:

Requirement ID                           Components             
rqPOC_IDS_SubsFeat_Enhn_6     Web-Apps,XDM-DataMgr   
rqPOC_IDS_SubsFeat_Enhn_3     XDM-DataMgr, DB
rqPOC_IDS_SubsFeat_Enhn_4     Web-Apps,XDM-DataMgr,Callp

"Components" column field is of drop down list - multiple choice selection type.

Using "Scaffolding Reporting", what specifically we are looking for is:::

Automatically create rows for each of our "Components" values added in the above table as below along with new column i,e Compliancy(i,e drop down list - single choice selection type) added for all the rows.
So that compliancy can be updated in a page by respective component primes individually into the reporting table generated as below.

Requirement ID                           Components              Compliancy
rqPOC_IDS_SubsFeat_Enhn_6      Web-Apps                  NO  rqPOC_IDS_SubsFeat_Enhn_6     XDM-DataMgr           YES
rqPOC_IDS_SubsFeat_Enhn_3      XDM-DataMgr           NO  
rqPOC_IDS_SubsFeat_Enhn_3      DB                              YES
rqPOC_IDS_SubsFeat_Enhn_4      Web-Apps                  NO  
rqPOC_IDS_SubsFeat_Enhn_4      XDM-DataMgr           YES
rqPOC_IDS_SubsFeat_Enhn_4      Callp                           YES

Also Using this reporting table generated, we should also able to export into XLS to filter our requirementIds for our tracking purpose.

- Manju

Andrey Khaneev _StiltSoft_

Hello Manju,

You can use Table Filter macro to filter your table or to export it to csv.