How to convert Excel file into SDA format in Ensemble

Question

Question

Smythe Smythee · Sep 20, 2022

#Caché #Ensemble

Hi ,

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

Thanks,

Smythee

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

Discussion (3)1

Log in or sign up to continue

Julian Matthews · Sep 21, 2022

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.

0 0

score 2 · Answer 1 · 2022-09-20T09:21:00-04:00

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.

score 0 · Answer 2 · 2022-09-20T15:18:18-04:00

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.

Thanks,

Smythee