Skip to main content
Question

I am trying to transform a list of data from a sql table to table like format - probably not making sense so I'll try an explain more


The following is how the data comes in using SQLCreator

beforeAnd this is how i want it to look

afterThe other tricky part is that there is no limit on the number of nar_num records (rec_seq) that can be linked to a single ass_num - at the moment I have a max of 17 but that could go up or down

 

I looked at the pivoter and didnt have any luck with that but i am new so maybe i am missing something.

Anyone have any ideas?

 

 

 

 

 

 

 

 

 

2 replies

Forum|alt.badge.img+2
  • January 20, 2021

@left65​ A combination of Aggregator followed by the HUB Custom transformer ListBreaker should do it.

  • Aggregator - use Group By : ass_num and create a list from attribute 'nar_num'. Use Mode: Attributes Only (or you could try ListBuilder)
  • ListBreaker - break up the list of 'nar_num'

  • Author
  • January 29, 2021
markatsafe wrote:

@left65​ A combination of Aggregator followed by the HUB Custom transformer ListBreaker should do it.

  • Aggregator - use Group By : ass_num and create a list from attribute 'nar_num'. Use Mode: Attributes Only (or you could try ListBuilder)
  • ListBreaker - break up the list of 'nar_num'

Thanks Markatsafe


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings