I'm trying to split DT-2 (attached) - Split by: Marker, Split Columns: Results. I'm wanting to "keep all" remaining columns.
The problem I am running into is that some markers have more rows than others. So when I split, it is combining the next "Lot" to backfill the other markers that have less than the maximum in the table.
For example, there should only be 3 values for CD19+ for lot 7587082, but after the split, it is showing 6, absorbing the values of the next lot, 7587083.
How do I get this to function properly? Am I missing something? Ideally I would like this to be in a script... which currently looks like this (all of script not shown, just the split):
dt3 = dt2 << Split( Split By( :Marker ), Split( :Results ));
Any and all help will be greatly appreciated!!!
