Skip to Content
avatar image
Former Member

Problem in the Table view of VC model

Hi all,

We have a created a table view using the BI query as source.

the table view has say 4 fields (Serial NO., Plant key, Material and Quantity) initially before submitting the parameters, once we enter some parameters and press submit button some extra fields are getting added at the end of the existing fields.

i.e the final result is Serial NO., Plant key, Material and Quantity, Plant, Material, Quantity. last 3 fields are undesired.

This is happening only when we select few fields in the define / Test Query setting (we are doing this to avoid unwanted fields while exporting data to excel).

Is there a way to avoid this addition of extra fields in the table view.

any help is highly appreciated.

regards,

Rk.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 02, 2009 at 08:45 AM

    Hi

    Are you getting these extra columns in 'Table' or while executing 'Define / Test Query'?

    If you are getting this in table then dont select anything while dragging the table from query. (When the systems ask to select the fields) Select the fields after creating the table & then see what is happening.

    Regards

    Sandeep

    Add comment
    10|10000 characters needed characters exceeded