I need to do a relatively complicated data table manipulation as a part of a solution. (Complicated, based on my initial efforts at solving it. . . I’m sure the gurus out there might think this is a piece of cake.) I would really appreciate some advice from more experienced developers on whether I should use my time do DT manipulation with data table activities or do a code activity (which I have never done). Any tips or ideas on how to actually execute the dt manipulation would be much appreciated as well.
Below is a s/c of the before (upper table) and desired after (lower table). The number of records in the before table will probably vary each time the automation is run. Please note the colors to help map the fields from before and after table.
ShelbyDT manipulation help.xlsx (18.5 KB)