Skip to main content
Solved

Prepend one dataset with other datasets

  • December 22, 2025
  • 3 replies
  • 53 views

ranga_tolapi
Contributor
Forum|alt.badge.img+11

Hello, there
I would like to prepend one dataset with other datasets and return other datasets as output. Please refer to the screenshot below, this should be done with only one workbench. Highly appreciate your thoughts.

 

 

Best answer by ranga_tolapi

Finally, I cracked it in my way, just incase if anybody interested in the solution.
 

 

3 replies

j.botterill
Influencer
Forum|alt.badge.img+56
  • Influencer
  • December 22, 2025

Multiple FeatureReader (workflow) transformers where you merge all attributes


ranga_tolapi
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • December 22, 2025

Hi ​@j.botterill 

Thank you for the response.

Enclosed two excel files, Parent.xlsx (Contains sheet TABLE-M) and Childs.xlsx (Contains sheets TABLE-N1, TABLE-N2 and TABLE-NN).

May I request your help to create the workspace using the enclosures and share with me, please.

Please make a note, in my actual scenario, child tables are not limited to only 3, their count can be 30 or 300.


ranga_tolapi
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • Best Answer
  • December 24, 2025

Finally, I cracked it in my way, just incase if anybody interested in the solution.