Hello,
I am new to JSL and attempting to create a script that will change the value of certain rows in a given column.
The general issue I am having is that my data is being categorized as from different locations, when in fact those sites are the same. So when I go to graph them, I get more groups than necessary.
Here is the snippet of code that I was hoping would accomplish my goal:
for each row(
if( As Column( dtSum:Name( "Originating Fab" )) == "D1C",
As Column( dtSum:Name( "Originating Fab" )) << Set Values( { "D1D" } );
);
);
Where 'dtSum' is my summary table and 'Originating Fab' is the column that depicts what location that row is from.
So in the above code, I want to change the Originating Site values from "D1C" to "D1D", since those are both the same location.
Any help would be greatly appreciated.
Thanks,
Lain