Dynamic records generation


I want to generate dynamically n records, based on column value. Lets say based Number_Streams , I want to create n records having same values for other columns, except the name. In name column I want to append alphabets dynamically.
Input data
Output Data
Thanks, any help would be appreciated.

I got the solution, the solution can be implemented in 2 ways.

  1. Using Javascript (Thanks to @Ajay_Chawda)
    Dynamic File Column read_2018_11_19 (1).slp (11.4 KB)
  2. Without using script…but the apporach is very much similar. I do not have enough time to explain. Please check the pipeline.
    Dynamic_records_without javascript_2018_11_24.slp (22.7 KB)