Hide columns when exporting to excel

[baghu]

Hi,

I've recently purchased V10.5 pro and need clarity with the below issue.

I'm importing an excel sheet as a data base and my excel sheet comes with some hidden fields(Columns). Once I complete my validation through Monarch I needed to export my workings as an excel sheet with the same hidden columns or more columns as hidden fields.

Is there any way I can do this?

Any help is appreciated.

Regards
Baghavathy

[Data Kruncher]

The only way that you can export to an Excel file that truly contains hidden columns is to build a summary that includes those fields, but on the appropriate tab for the field's properties, set the hidden checkbox. Then export that summary to the Excel file.

For Item and Measure fields, you'll find a Hidden checkbox on the General tab.

For Key fields, use the "Hide the key column" checkbox on the Display tab.

This may take some trial and error time to get the desired layout just right, but it can be done successfully.

HTH,
Kruncher

[baghu]

Thanks for your help and it worked.