Smythe Smythee · Sep 20, 2022

How to convert Excel file into SDA format in Ensemble

Hi ,

How to Convert Excel message into a SDA3 format in Ensemble?



Product version: Ensemble 2018.1
$ZV: Cache for Windows (x86-64) 2018.1.1 (Build 312_1_18937U) Fri Apr 26 2019 17:58:36 EDT
0 91
Discussion (3)1
Log in or sign up to continue

If you're working with a CSV, then you could look at the Record Mapper or Complex Record Mapper depending on the input format. From there, you could then create a transform that uses the generated class from the record mapper as your source, and then the appropriate SDA class as your destination.

However, if you're working with an actual xls/xlsx file, then I'm out of ideas.

Hi Julian ,

I am using Record Map  as an input. Can you help me what are the classes i need to use for business process and Business Operation.



If you have a record map configured and have the generated class, then the next step would be to use this generated class in a transform as your source. From there, you can transform the data into the SDA class you have set in your target for transform.

Once you have this SDA message, you can send it wherever your requirements need you to send them.