Hi,
I have scripted an addin to query a sql table and then group/move some of the columns with an action below. It does group the columns but it also leaves them outside of the group post query. How do I not have them displayed outside of the group?
Open Database(
"DSN=BB Analytics Data Warehouse;Description=BB Analytics Data Warehouse;UID=;Trusted_Connection=Yes;APP=JMP;WSID=SFX-5GCN2M1;DATABASE=BBAnalytics",
"select * from dbo.NewCombinded",
"NewCombinded"
);
// Move selected column: NextEndTime
Data Table( "NewCombinded" ) << Move Selected Columns(
{:NextEndTime},
after( :NextStartTime )
);
// Group columns
Data Table( "NewCombinded" ) << Group Columns(
"FermCount etc.",
{:FermCount, :Volume, :BeerwellCount, :BWVol, :YP_Vol, :Latitude, :Longitude,
:Design, :Tech}
);
// Rename column group: FermCount etc. → Plant Meta Data
Data Table( "NewCombinded" ) << Rename Column Group(
"FermCount etc.", "Plant Meta Data"
);
// Group columns
Data Table( "NewCombinded" ) << Group Columns(
"Chlorine Total etc.",
{:Chlorine Total, :Backset Solids, :Beerwell Drop pH, :Slurry %DS, :Flour Fines,
:SlurrypH, :BacksetRate, :Level, :Temperature, :"Chlorine (gal)"n,
:"Isostab (gal)"n, :Lipase Addition, :"PhibroXact 25/75 Addition"n,
:"Sulfuric (gal)"n, :"Urea (gal)"n, :Lactoside247 Total, :Max Ferm Temp,
:Phibro Total, :Sulfuric Acid Total}
);
// Rename column group: Chlorine Total etc. → Batch Ingredients
Data Table( "NewCombinded" ) << Rename Column Group(
"Chlorine Total etc.", "Batch Ingredients"
);
// Group columns
Data Table( "NewCombinded" ) << Group Columns(
"Yeast Dead Cells etc.",
{:Yeast Dead Cells, :Yeast Live Cells, :Yeast Total Cells,
:"Yeast 1 Dose (gal)"n, :"Yeast 2 Dose (gal)"n, :"Yeast Chlorine (gal)"n,
:Yeast Enzyme Amount, :"Yeast Urea (gal)"n, :Yeast Chlorine Totalizer,
:Yeast Urea, :Yeast yTech Yeast Total, :Yeast Enzyme, :Yeast CIP Valve,
:Yeast Level, :Yeast Temperature}
);
// Rename column group: Yeast Dead Cells etc. → Yeast Ingredients and Setpoints
Data Table( "NewCombinded" ) << Rename Column Group(
"Yeast Dead Cells etc.", "Yeast Ingredients and Setpoints"
);
// Rename column group: Batch Ingredients → Batch Ingredients and Setpoints
Data Table( "NewCombinded" ) << Rename Column Group(
"Batch Ingredients", "Batch Ingredients and Setpoints"
);
// Move selected column: FermHrs
Data Table( "NewCombinded" ) << Move Selected Columns(
{:FermHrs},
after( :FermHrs )
);
// Move selected column: Ferm Scrubber Water Ethanol
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Ferm Scrubber Water Ethanol},
after( :Glucose )
);
// Move selected column: Ferm Scrubber Water Ethanol
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Ferm Scrubber Water Ethanol},
after( :NextEndTime )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Batch Ingredient #1, :Batch Ingredient #2, :Batch Ingredient #3,
:Enzyme Amount, :Enzyme Amount 2, :Comments, :Batch Ingredient#1 Description,
:Batch Ingredient#2 Description, :Batch Ingredient#3 Description, :Enzyme Type,
:Enzyme Type 2, :Initials},
after( :Acetic )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Batch Ingredient #1, :Batch Ingredient #2, :Batch Ingredient #3,
:Enzyme Amount, :Enzyme Amount 2, :Comments, :Batch Ingredient#1 Description,
:Batch Ingredient#2 Description, :Batch Ingredient#3 Description, :Enzyme Type,
:Enzyme Type 2, :Initials},
after( :NextEndTime )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n},
after( :Ferm Drop Min pH )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n},
after( :Ferm Drop Final Density )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n},
after( :Ferm Drop Enzyme Total )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n},
after( :Ferm Drop Avg Temp )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n},
after( :NIR DDGS Storgage Fat )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n},
after( :Malt )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Yeast Lot Number, :Yeast Lot Number #2, :Yeast Type},
after( :Malt )
);
// Group columns
Data Table( "NewCombinded" ) << Group Columns(
"Glucose etc.",
{:Glucose, :Acetic, :Lactic, :Malt, :DDGS AFLATOXIN, :DDGS DON,
:NIR DDGS Storage Protein, :NIR DDGS Storgage Fat, :NIR DDGS Storgage Gluc,
:NIR DDGS Storgage Mst, :Ferm Drop Acetic,
:"Ferm Drop Ethanol (Solids and Glyc Adj to Yield)"n, :Ferm Drop Avg Temp,
:Ferm Drop Batch Id, :"Ferm Drop Batch ID (NIR)"n, :Ferm Drop DP3,
:Ferm Drop DP4, :Ferm Drop DS, :Ferm Drop Enzyme Total, :Ferm Drop Ethanol,
:"Ferm Drop Ethanol (NIR)"n, :"Ferm Drop Ethanol (Solids Adj)"n,
:"Ferm Drop Ethanol (Solids and Glyc Adj)"n, :Ferm Drop Formic, :Ferm Drop Fruc,
:Ferm Drop Gluc, :"Ferm Drop Gluc (NIR)"n, :Ferm Drop Glyc, :Ferm Drop Lactic,
:Ferm Drop Malt, :Ferm Drop pH, :"Ferm Drop pH (NIR)"n, :Ferm Drop Starch,
:Ferm Drop Total Sugars, :Ferm Starch Delta, :Ferm Starch In, :Ferm Starch Out,
:Gallons Lost, :Significantly Different Batch}
);
// Rename column group: Glucose etc. → Drop End of Ferm Data
Data Table( "NewCombinded" ) << Rename Column Group(
"Glucose etc.", "Drop End of Ferm Data"
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:FermCount, :Volume, :BeerwellCount, :BWVol, :YP_Vol, :Latitude, :Longitude,
:Design, :Tech},
after( :Sulfuric Acid Total )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Glucose, :Acetic, :Lactic, :Malt, :DDGS AFLATOXIN, :DDGS DON,
:NIR DDGS Storage Protein, :NIR DDGS Storgage Fat, :NIR DDGS Storgage Gluc,
:NIR DDGS Storgage Mst, :Ferm Drop Acetic,
:"Ferm Drop Ethanol (Solids and Glyc Adj to Yield)"n, :Ferm Drop Avg Temp,
:Ferm Drop Batch Id, :"Ferm Drop Batch ID (NIR)"n, :Ferm Drop DP3,
:Ferm Drop DP4, :Ferm Drop DS, :Ferm Drop Enzyme Total, :Ferm Drop Ethanol,
:"Ferm Drop Ethanol (NIR)"n, :"Ferm Drop Ethanol (Solids Adj)"n,
:"Ferm Drop Ethanol (Solids and Glyc Adj)"n, :Ferm Drop Formic, :Ferm Drop Fruc,
:Ferm Drop Gluc, :"Ferm Drop Gluc (NIR)"n, :Ferm Drop Glyc, :Ferm Drop Lactic,
:Ferm Drop Malt, :Ferm Drop pH, :"Ferm Drop pH (NIR)"n, :Ferm Drop Starch,
:Ferm Drop Total Sugars, :Ferm Starch Delta, :Ferm Starch In, :Ferm Starch Out,
:Gallons Lost, :Significantly Different Batch},
after( :Tech )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Yeast Lot Number, :Yeast Lot Number #2, :Yeast Type,
:"Yeast Dead Cells (Cells/mL)"n, :"Yeast Live Cells (Cells/mL)"n,
:Yeast Dead Cells, :Yeast Live Cells, :Yeast Total Cells, :"Yeast 1 Dose (gal)"n,
:"Yeast 2 Dose (gal)"n, :"Yeast Chlorine (gal)"n, :Yeast Enzyme Amount,
:"Yeast Urea (gal)"n, :Yeast Chlorine Totalizer, :Yeast Urea,
:Yeast yTech Yeast Total, :Yeast Enzyme, :Yeast CIP Valve, :Yeast Level,
:Yeast Temperature},
after( :Significantly Different Batch )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Ferm Drop Fill Density, :Ferm Drop Final Density, :"Ferm Drop Hours (NIR)"n,
:Ferm Drop Hrs, :Ferm Drop Min pH},
after( :Ferm Drop Ferm Number )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Ferm Drop Ferm Number, :Ferm Drop Fill Density, :Ferm Drop Final Density,
:"Ferm Drop Hours (NIR)"n, :Ferm Drop Hrs, :Ferm Drop Min pH},
after( :NextEndTime )
);
// Move selected column: Total Backset To Ferm
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Total Backset To Ferm},
after( :NextEndTime )
);
// Move selected column: Ferm Drop W2M Ratio
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Ferm Drop W2M Ratio},
after( :NextEndTime )
);
// Move selected columns
Data Table( "NewCombinded" ) << Move Selected Columns(
{:Month1, :Year1, :DateFermBatchStart, :Recipe Batch #},
after( :NextStartTime )
);
