Problem in the Table view of VC model

[Former Member]

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.

[Former Member · Accepted solution]

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