Skip to main content
Solved

Grouping records in export operation

  • September 15, 2022
  • 1 reply
  • 71 views

alexAguilarMx
Data Pioneer
Forum|alt.badge.img+2

Hi,

I am creating an export operation, I have an entity 01, with a list of users and an entity 02 with email addresses:

Entity structure

 

I need to convert this to an export file with the next structure:

 

Export file layout

I would to know if there a step to help me grouping the data for this purpose.

 

Thanks in advance,

Alejandro

Best answer by alexAguilarMx

A bit of more context

 

I used a Record Descriptor Builder for group the data and identify the position of the mail_address# based on the EntityId, then I used  a Representative Creator for change the rows as columns. I am not sure if there are a best way to do that.

1 reply

alexAguilarMx
Data Pioneer
Forum|alt.badge.img+2
  • Author
  • Data Pioneer
  • Answer
  • September 16, 2022

A bit of more context

 

I used a Record Descriptor Builder for group the data and identify the position of the mail_address# based on the EntityId, then I used  a Representative Creator for change the rows as columns. I am not sure if there are a best way to do that.