6 Replies Latest reply: Apr 23, 2015 8:12 AM by Gabriel Oluwaseye

# need a blank row in straigjt table

Hi,

I have created a straight table and it has one dimensional column and 9 expressions are there. But at end of the table i need a blank row needs to be inserted. Is there any way to achieve this blank row.

Regards,

Kumar

• ###### Re: need a blank row in straigjt table

I want empty row, but u r saying column.

Regards,

Kumar

• ###### Re: need a blank row in straigjt table

Hi

Try loading a blank row from inline load and concatenate the table with original table so your table have a ' ' value then in straight table show all values also uncheck suppress missing values.

Thanks

BKC

• ###### Re: need a blank row in straigjt table

Hi Chandel,

I have a dimension called Day and deriving the expressions using set analysis. The data is as below. Need to achieve the last row which is =(C8/AVERAGE(C5:C7))-1 where C5=39,233; c6=30924; C7=27609 and C8=39443.

Regards,

Kumar

• ###### Re: need a blank row in straigjt table

Hi Robert,

I have a dimension called Day and deriving the expressions using set analysis. The data is as below. Need to achieve the last row which is =(C8/AVERAGE(C5:C7))-1 where C5=39,233; c6=30924; C7=27609 and C8=39443.

Regards,

Kumar

• ###### Re: need a blank row in straigjt table

Hi,

Where is the source data?

I have an idea.

Table:

Name,  Value
AAA, 00010
BBB, 00020
CCC, 3020567
DDD, 34567
EEE, 5678
'', ''
]
;

Have Name  as your dimension and value as your expression, this will give you your extra blank row.

Also, when you load your qvd file (assume qvd is used) just concatenate exact same field names but the value will be quote (' '). To achieve optimization I will have this stored in qvd file and just concatenate it to any table in where I want to the extra field as blank.

Give it a try and let us know the outcome.