BIX Extract in a .xls or .xlsx format
I have a requirement to generate an .xls or .xlsx format from BIX. Can someone provide some guidance on how to perform this?
Thanks.
Empower Retirement
IN
Please follow the below document for the BIX implementation ,
https://docs-previous.pega.com/bix-731-user-guide?check_logged_in=1
the supported output formats for BIX is
1. XML-
2.Comma Separated Values(CSV)-Export instances of classes as comma-separated values
3.DatabaseSchema—Export data from the PegaRULES database directly into another relational database
Healthfirst Inc
US
@MITHUN.P Thank you for your reply. I do see these three as output for the formats.
Do you have experience in converting a .csv to a .xls after the BIX export?
Healthfirst Inc
US
Thank you for your reply. I do see the outputs for the formats but .xls is not one of them (only .csv).
Do you have experience in converting a .csv to a .xls after the BIX export has completed?
My requirement is to export the data but then provide in an excel format (not .csv) before the business receives.
thanks in advance for your assistance.
EY
ES
@ScottR15 You can make an outside conversion by a procedure in VBA in excel...or it is necessary to do it through the platform by requirements?