*DATASET_COMPUTE_STAR_RATING

Description: Compute the Occupant injury star-rating based on the dataset with values for HICd and Peak value sof Chest, Femur and Neck values

Syntax: dataset_compute_star_rating(dataset,new_colname,hi_cd,peak_chest_deflectioninmm,peak_femur_loadink_n,peak_neck_ni_jink_n,peak_neck_tensionink_n,peak_neck_compressionink_n,occupant_type,unit_system)

Inputs

ID	Name	Type	Default	Remarks
1	DWOIV	dataset		Dataset with Occupant Injury values <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	New Column Name	textarea		New Column Name
3	HICd	scalar
4	Peak Chest Deflection in mm	scalar
5	Peak Femur Load in kN	scalar
6	Peak Neck NIJ in kN	scalar
7	Peak Neck Tension in kN	scalar
8	Peak Neck Compression in kN	scalar
9	Occupant Type	select
10	Unit System	select

Outputs

ID	Name	Type	Remarks
1	dataset_compute_star_rating_output_1	dataset

*DATASET_SYNC_CURVE_COLUMNS

Description: Sync X values for the selected columns

Syntax: dataset_sync_curve_columns(dataset_1,target_column,sync_type,monotonic,digitize)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset containing the column <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Column	textarea		Choose Column
3	Sync type	select		Sync type
4	Monotonic	select		Monotonic
5	Digitize	scalar		Digitize

Outputs

ID	Name	Type	Remarks
1	Synced Dataset	dataset

*DATASET_GET_MAX_BIN_RANGE

Description: Bin values based on Column and return the bin that has the most number of items

Syntax: dataset_get_max_bin_range(dataset_1,target_column,num_of_bins,min_max)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset containing the column <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Column	textarea		Choose Column
3	NOBCN	textarea		Number of BinsNew column name
4	Bin bound type	select		Bin bound type

Outputs

ID	Name	Type	Remarks
1	Bin Value	scalar

*DATASET_RUN_SENTIMENT_ANALYSIS

Description: Run sentiment analysis on a dataset column

Syntax: dataset_run_sentiment_analysis(dataset_1,target_column,new_col_name,positive_threshold,positive_words,negative_words)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset containing the column <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Column	textarea		Choose Column
3	New column name	textarea		New column name
4	Positive threshold value	textarea		Positive threshold value
5	Additional Positive words	textarea		Additional Positive words
6	Additional Negative words	textarea		Additional Negative words

Outputs

ID	Name	Type	Remarks
1	dataset_run_sentiment_analysis_output_1	dataset

*DATASET_GET_CURVE_FROM_COLUMN

Description: Curve from Column

Syntax: dataset_get_curve_from_column(dataset_1,col_name)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Curves <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Name	float		Column Name

Outputs

ID	Name	Type	Remarks
1	dataset_get_curve_from_column	vector

*DATASET_RENAME_CURVES_IN_COLUMN

Description: Dataset Rename Curves In Column

Syntax: dataset_rename_curves_in_column(dataset_1,curve_col,name_by)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Curve Column	textarea		Curve Column whose names are to be changed. All curves will have the names specified by the columns below
3	CTWBUFN	textarea		Values of this column will be used for naming the curve

Outputs

ID	Name	Type	Remarks
1	dataset_rename_columns_output_1	dataset

*DATASET_TO_KEYVALUE

Description: Dataset To Keyvalue

Syntax: dataset_to_keyvalue(dataset_1)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be converted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	dataset_to_keyvalue_output_1	keyvalue

*DATASET_GET_PROGRESSIVE_CRUSH_FACTOR

Description: Dataset Get Progressive Crush Factor

Syntax: dataset_get_progressive_crush_factor(dataset_1)

Inputs

ID	Name	Type	Default	Remarks
1	Crush dataset	dataset		Dataset from *CURVES_GET_CRASHWORTHINESS that contains the crush information <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	dataset_get_progressive_crush_factor_output_1	scalar

*DATASET_SIMULATED_ANNEALING_OPTIMIZER

Description: Find the optimize X based on the simulated annealing

Syntax: dataset_simulated_annealing_optimizer(dataset_1,inputs,targets,num_iterations,step_size,initial_temperature,model_type,model_params,shrink_factor,return_type,normalize,target_value,objective,grid_search,constraints,mathmodel_id,stopping_criteria)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Curve which contains the x and y points <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Inputs	textarea		Columns that are inputs for the dataset
3	Targets	textarea		Columns that represents the Targets
4	Number of Iterations	scalar		Number of Iterations
5	Step size	scalar		Step size
6	Initial Temperature	scalar		Initial Temperature
7	Model type	select		Model type
8	Model Parameters	form-input-table		Model Parameters
9	Shrink Factor	scalar		Shrink Factor
10	Return type	select		Return type
11	Data Normalization Type	select		Data Normalization Type
12	Target Value	textarea		Target value for optimum
13	Objective	select		Objective
14	Grid Search	select		Grid Search
15	Constraints	dataset		Dataset with constraints. The expected columns are needle, condition, target. Where needle is the column that is meet the condition specified by target. Ex needle=variable1 condition=gt and target=10.0 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
16	Mathmodel	remote_lookup		Mathmodel
17	STOP_RATIO	scalar		When convergence is not improving after STOP_RATIO*NUM_ITERATIONS, the optimization is terminated. If STOP < 0, the optimization is stopped when convergence is not improving within abs(STOP_RATIO) steps

Outputs

ID	Name	Type	Remarks
1	dataset_simulated_annealing_optimizer_output_1	dataset

*DATASET_CROSSPLOTCOLUMNS

Description: Crossplot two columns from a dataset

Syntax: dataset_crossplotcolumns(src_dataset,x-column,y-column,sort_x_values)

Inputs

ID	Name	Type	Default	Remarks
1	NOTD	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	X-Column	scalar		Column name as x values
3	Y-Column	scalar		Column name as y values
4	Sort X Values	select		Sort X Values

Outputs

ID	Name	Type	Remarks
1	dataset_crossplotcolumns_output_1	vector

*DATASET_UNIQUENUM

Description: Compute the unique number of occurences in values

Syntax: dataset_uniquenum(response,column_name)

Inputs

ID	Name	Type	Default	Remarks
1	Response	keyvalue		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Name	scalar		Column name of the dataset to be checked

Outputs

ID	Name	Type	Remarks
1	dataset_uniquenum_output_1	scalar

*DATASET_COMPUTE_PARETO_FRONT_SORTER

Description: Compute sorted pareto front from provided dataset

Syntax: dataset_compute_pareto_front_sorter(dataset1,columns,criteria,constraints,targets,limit)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		This is the dataset containing records to find the optimal records. <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Columns	scalar		These columns specified will be used to find the optimum
3	Objective	scalar		For multiple columns, the criteria can be specified as a list separated by a commas as min,max with one objective per column
4	Constraints	dataset		Constraints that includes needle, condition, and target column to use. Example: needle=var1, condition=gt, target=2.0 will allow var1 to be always greater than 2.0 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
5	Targets	textarea		Targets values for selected columns can be specified in the case of parameter identification. Multiple targets can be specified as target1:20,target2:30…
6	Limit	scalar		Number of optimum records to return. The default is 1

Outputs

ID	Name	Type	Remarks
1	dataset_compute_pareto_front_sorter_output_1	dataset

*DATASET_JOIN_ROW

Description: Join a row to all rows of the destination dataset

Syntax: dataset_join_row(source_dataset,dest_dataset,source_column,source_row_index)

Inputs

ID	Name	Type	Default	Remarks
1	Source	dataset		Source dataset from which the row will be joined to the destination. If the source contains more than 1 row, the first row will be chosen <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Destination dataset	dataset		All rows will have the same values as the first row in the source_dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Source columns	scalar		Columns to add from source dataset
4	Source dataset index	scalar		Specify the row index if a particular row from the destination is to be joined. The default is first.

Outputs

ID	Name	Type	Remarks
1	dataset_join_row_output_1	dataset

*DATASET_SET_CELL_VALUE

Description: Set the cell value from given dataset

Syntax: dataset_set_cell_value(datasetname,row_index,col_index,new_value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Row Index	scalar		First row starts at 0
3	Col Index	scalar		First column starts a 0
4	New Value	scalar		New Value

Outputs

ID	Name	Type	Remarks
1	dataset_get_cell_value_output_1	dataset

*DATASET_GET_CELL_VALUE_IMAGE

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_image(datasetname,row_index,col_index)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Row Index	scalar		First row starts at 0
3	Col Index	scalar		First column starts at 0

Outputs

ID	Name	Type	Remarks
1	dataset_get_cell_value_output_1	image

*DATASET_GET_CELL_VALUE

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value(datasetname,row_index,col_index,missing_value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Row Index	scalar		First row starts at 0
3	Col Index	scalar		First column starts at 0
4	Missing Value	scalar		If the dataset does not have the row or column number

Outputs

ID	Name	Type	Remarks
1	dataset_get_cell_value_output_1	scalar

*DATASET_GET_CELL_VALUE_VECTOR

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_vector(datasetname,row_index,col_index)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Row Index	scalar		First row starts at 0
3	Col Index	scalar		First column starts at 0

Outputs

ID	Name	Type	Remarks
1	dataset_get_cell_value_output_1	vector

*DATASET_GET_CELL_VALUE_KEYVALUE

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_keyvalue(datasetname,row_index,col_index)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Row Index	scalar		First row starts at 0
3	Col Index	scalar		First column starts at 0

Outputs

ID	Name	Type	Remarks
1	dataset_get_cell_value_output_1	keyvalue

*DATASET_GET_CELL_VALUE_DATASET

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_dataset(datasetname,row_index,col_index)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Row Index	scalar		First row starts at 0
3	Col Index	scalar		First column starts at 0

Outputs

ID	Name	Type	Remarks
1	dataset_get_cell_value_dataset_output_1	dataset

*DATASET_RANDOM_SAMPLER

Description: Creates a random dataset

Syntax: dataset_random_sampler(source_dataset,num_samples,reset_index)

Inputs

ID	Name	Type	Default	Remarks
1	Source	dataset		Source dataset from which the random sampling is to be taken <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Number of samples	scalar		Number of samples to create
3	Reset Index	select		Resets the indexes of rows in case they need to be treated as a new dataset

Outputs

ID	Name	Type	Remarks
1	dataset_random_sampler_output_1	dataset

*DATASET_CREATE_FROM_KEYVALUES

Description: Create dataset based on the key values provided

Syntax: dataset_create_from_keyvalues(keyvalue)

Inputs

ID	Name	Type	Default	Remarks
1	Key value input	keyvalue		Keyvalue to be used for combining <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	dataset_create_from_keyvalues_output_1	dataset

*DATASET_UNIQUE

Description: Checks dataset for unique column name

Syntax: dataset_unique(datasetname,column_name)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset name	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Name	scalar		Column name of the dataset to be checked

Outputs

ID	Name	Type	Remarks
1	dataset_unique_output_1	set

*DATASET_NORMALIZE

Description: Normalize columns in the dataset

Syntax: dataset_normalize(dataset_1,columns,normalization_type)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset whose norm is to be completed <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Columns	scalar		Columns whose norm is to be completed
3	Normalization Type	select		Type of normalization. Default standard is more robust

Outputs

ID	Name	Type	Remarks
1	dataset_normalization_output_1	dataset

*DATASET_GET_NORM

Description: Compute the norm of a dataset

Syntax: dataset_get_norm(dataset_1,norm_type)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset whose norm is to be completed <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Norm Type	select		Type of norm

Outputs

ID	Name	Type	Remarks
1	dataset_norm_output_1	scalar

*DATASET_GET_MIN_SAMPLE_SIZE

Description: Compute minimum sample size

Syntax: dataset_get_min_sample_size(dataset_1,columns,confidence,margin_error,z_score_type)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Columns	scalar		Columns whose norm is to be completed
3	Confidence	select		Confidence level
4	Margin of Error	select		Confidence level
5	Z Score Type	select		Type of z_score

Outputs

ID	Name	Type	Remarks
1	dataset_sample_size_output_1	dataset

*DATASET_COMBINE_COLUMN

Description: Combine datasets based on primary keys

Syntax: dataset_combine_column(dataset1,dataset2,primarykeys,columntocombine)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset1	dataset		Dataset1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Dataset2	dataset		Dataset2 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Primary keys	scalar		Primary keys
4	Column to combine	scalar		Column to combine

Outputs

ID	Name	Type	Remarks
1	dataset_combine_column_output_1	dataset

*DATASET_ADD_STATIC_COLUMN

Description: Combine datasets based on primary keys

Syntax: dataset_add_static_column(dataset1,col_name,column_value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset1	dataset		Dataset1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Col Name	scalar		Col Name
3	Column Value	scalar		Column Value

Outputs

ID	Name	Type	Remarks
1	dataset_add_static_column_output_1	dataset

*DATASET_WRITE_TO_FILE

Description: Write dataset to file

Syntax: dataset_write_to_file(responsetoextractfrom,file_name)

Inputs

ID	Name	Type	Default	Remarks
1	RTEF	dataset		dataset to be written into file <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	File Name	scalar		File name the written dataset will be saved as

Outputs

ID	Name	Type	Remarks
1	dataset_write_to_file_output_1	dataset

*DATASET_SUBTRACT

Description: Subtract two datasets and return the difference

Syntax: dataset_subtract(dataset_1,dataset2,diff_type)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset 1	dataset		Dataset 1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Dataset 2	dataset		Dataset 2 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Type of Difference	select		Type of Difference

Outputs

ID	Name	Type	Remarks
1	dataset_subtract_output_1	dataset

*DATASET_JOIN

Description: Combine datasets based on primary keys

Syntax: dataset_join(dataset1,dataset2,join_type,primarykeys,datset1_columns_to_include,datset2_columns_to_include,prefixfordataset1columns,prefixfordataset2columns)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset1	dataset		Dataset1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Dataset2	dataset		Dataset2 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Join Type	select		Join Type
4	Primary keys	scalar		Primary keys
5	DCTI	textarea		Dataset1 columns to include
6	DCTI	textarea		Dataset2 columns to include
7	Dataset1 Column prefix	scalar		Dataset1 Column prefix
8	D2CP	scalar		Dataset 2 Column prefix

Outputs

ID	Name	Type	Remarks
1	dataset_join_output_1	dataset

*DATASET_GET_GROUPED_SUMMARY

Description: Get dataset summary

Syntax: dataset_get_grouped_summary(dataset,group_by,columns)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Group By	scalar		Group by these columns
3	Choose Columns	scalar		Restrict the schema generation to these columns

Outputs

ID	Name	Type	Remarks
1	dataset_get_summary_output_1	dataset

*DATASET_GET_CURVES_FROM_COLUMN

Description: Get curves from a column

Syntax: dataset_get_curves_from_column(dataset_1,curve_columns)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Curve Column	scalar		Column that contains the curves

Outputs

ID	Name	Type	Remarks
1	dataset_get_curves_from_column_output_1	vector

*DATASET_GET_NUMERIC_COLUMN_STATS

Description: Get Stats for numeric columns

Syntax: dataset_get_numeric_column_stats(dataset_1,numeric_columns)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Numeric Columns	scalar		Column that contains the curves

Outputs

ID	Name	Type	Remarks
1	dataset_stats_1	dataset

*DATASET_ADD_CURVES_TO_COLUMN

Description: Add curves to a column

Syntax: dataset_add_curves_to_column(dataset_1,new_column_name,curves)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Name	scalar		New column name
3	Curves	vector		Curves to be added <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#curveinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	dataset_add_curves_to_column_output_1	dataset

*DATASET_GET_SUMMARY

Description: Get dataset summary

Syntax: dataset_get_summary(dataset,columns)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Columns	scalar		Restrict the schema generation to these columns

Outputs

ID	Name	Type	Remarks
1	dataset_get_summary_output_1	dataset

*DATASET_GET_SCHEMA

Description: Get schema for the columns

Syntax: dataset_get_schema(dataset,columns)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Columns	scalar		Restrict the schema generation to these columns

Outputs

ID	Name	Type	Remarks
1	dataset_get_schema_output_1	dataset

*DATASET_COMBINE_SCALARS

Description: Combine scalars

Syntax: dataset_combine_scalars(headers,header_delimiter,row_delimiter,responsetoextractfrom)

Inputs

ID	Name	Type	Default	Remarks
1	Headers	scalar		Headers
2	Header Delimiter	select		Header Delimiter
3	Row Delimiter	select		Row Delimiter
4	RTEF	scalar		Response to extract from

Outputs

ID	Name	Type	Remarks
1	dataset_combine_scalars_output_1	dataset

*DATASET_ADD_COLUMN_BY_EXPRESSION

Description: Add column by expression

Syntax: dataset_add_column_by_expression(dataset,new_columnname,expression)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	New Column name	textarea
3	Expression	textarea

Outputs

ID	Name	Type	Remarks
1	dataset_add_column_by_expression_output_1	dataset

*DATASET_UNIFY_KEYS

Description: Unify columns in the dataset

Syntax: dataset_unify_keys(dataset,null_replacement_type)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Null replacement type	select		Null replacement type

Outputs

ID	Name	Type	Remarks
1	dataset_add_column_by_expression_output_1	dataset

*DATASET_ADD_ROW

Description: Dataset Add Row

Syntax: dataset_add_row(dataset,records,position)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	records	dataset
3	Position	select		Position

Outputs

ID	Name	Type	Remarks
1	dataset_add_row_output_1	dataset

*DATASET_COMPUTE_DERIVATIVES

Description: Dataset Compute Derivatives

Syntax: dataset_compute_derivatives(dataset_1,inputs,targets,build_ffd,value_type,normalize)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Inputs	scalar
3	Targets	scalar
4	Build FFD if not one	select		Learn from the dataset and build a FFD dataset
5	Value type	select		Value of derivative to report from neibhoring points. Default uses the average values of derivatives from all neibhoring points
6	Normalize the data	select		Normalize the data prior to computing the derivatives

Outputs

ID	Name	Type	Remarks
1	dataset_compute_derivatives_output_1	dataset

*DATASET_GET_CONTEXT

Description: Dataset Get Context

Syntax: dataset_get_context(dataset_1,context_text)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Context Template	textarea

Outputs

ID	Name	Type	Remarks
1	Context	textarea

*DATASET_REDUCE

Description: Reduce Dataset to single column and unify keys

Syntax: dataset_reduce(dataset)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to reduce <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	Dataset Reduced	dataset

*DATASET_SCAN_OUT_OF_RANGE_ROWS

Description: Scan the dataset and compare its column values to a reference dataset and flag if they are in or out of range of the reference values

Syntax: dataset_scan_out_of_range_rows(dataset,dataset_ref,cols)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to scan <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Reference Dataset	dataset		Dataset to scan <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Columns to Scan	select

Outputs

ID	Name	Type	Remarks
1	Dataset Scanned	dataset

*DATASET_REGRESSION_PREDICT

Description: Dataset Regression Predict

Syntax: dataset_regression_predict(dataset,meta-model,new_column_name)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Meta-Model	keyvalue		Meta-Model <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	New Column Name	textarea		New Column Name. By Default its the name as trained

Outputs

ID	Name	Type	Remarks
1	dataset_regression_predict_output_1	keyvalue

*DATASET_REGRESSION_BUILD

Description: Dataset Regression Build

Syntax: dataset_regression_build(dataset,independent_column,dependent_columns,order)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Independent Column	textarea		Independent Column
3	Dependent Columns	textarea		Dependent Columns
4	Order	scalar		Order

Outputs

ID	Name	Type	Remarks
1	dataset_regression_build_output_1	keyvalue

*DATASET_GET_ROW_BY_CONDITION

Description: Dataset Get Row By Condition

Syntax: dataset_get_row_by_condition(dataset,columntocheck,operator,value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column to check	scalar		Column name of the dataset to be checked
3	Operator	select		Operator
4	Value	scalar		Expected value

Outputs

ID	Name	Type	Remarks
1	dataset_get_row_by_condition_output_1	keyvalue

*DATASET_GET_ROWS_BY_CONDITION

Description: Dataset Get Rows By Condition

Syntax: dataset_get_rows_by_condition(dataset,columntocheck,operator,value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column to check	scalar		Column name of the dataset to be checked
3	Operator	select		Operator
4	Value	scalar		Expected value

Outputs

ID	Name	Type	Remarks
1	dataset_get_rows_by_condition_output_1	dataset

*DATASET_GET_COLUMN_VALUES

Description: Dataset Get Column Values

Syntax: dataset_get_column_values(dataset_1,column_names,col_delimiter,row_delimiter,type_of_value_to_return)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Names	scalar		Column name of the dataset to be checked
3	col_delimiter	scalar		Delimiter used to separate columns
4	row_delimiter	scalar		Delimiter used to separate rows
5	TOVTR	select		Type of value to return

Outputs

ID	Name	Type	Remarks
1		scalar

*DATASET_GET_NUM_ROWS_BY_CONDITION

Description: Dataset Get Num Rows By Condition

Syntax: dataset_get_num_rows_by_condition(dataset,columntocheck,conditions)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column to check	scalar		Column name of the dataset to be checked
3	Conditions	labelcondition		Conditions to be satisfied in order for values to be included

Outputs

ID	Name	Type	Remarks
1	dataset_get_num_rows_by_condition_output_1	scalar

*DATASET_SORT_BY_ROW

Description: Dataset Sort By Row

Syntax: dataset_sort_by_row(dataset,compare_row,diff_type,order,limit,return_type,columns,normalize)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Compare Dataset	dataset		First row of this dataset will be used fof computing the difference <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Diff Type	select		Method of difference computation
4	Order	select		Order of the returning dataset
5	Limit	scalar		Limit the returning dataset rows to this number
6	Return Type	select		Type of returning dataset
7	Columns to match	scalar		These columns will be used to compute the diference and find the closest match
8	Normalize	select		Normalize columns before sorting

Outputs

ID	Name	Type	Remarks
1	Dataset	dataset

*DATASET_RECONSTRUCT_CURVE_FROM_PREDICTIONS

Description: Dataset Reconstruct Curve From Predictions

Syntax: dataset_reconstruct_curve_from_predictions(dataset_1,raw_column_name,dataset,prediction_points,reconstruction_type,sync_x_values,x_prediction_points)

Inputs

ID	Name	Type	Default	Remarks
1	Original Dataset	dataset		This dataset contains the points that will be original dataset with curves <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Original Curve Column	scalar		Column name to format
3	Prediction Dataset	dataset		This dataset contains the prediction curve points <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
4	CNTCTPP	scalar		Column names that contains the prediction points
5	Type of reconstruction	select		Type of reconstruction
6	Sync x-values	select		Sync x-values
7	CNTCTXP	scalar		Column names that contains the x-predicted points

Outputs

ID	Name	Type	Remarks
1	dataset_reconstruct_curve_from_predictions_output_1	dataset

*DATASET_GET_NUM_COLUMNS

Description: Dataset Get Num Columns

Syntax: dataset_get_num_columns(dataset)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	Number of Columns	scalar

*DATASET_CREATE_EMPTY

Description: Dataset Create Empty

Syntax: dataset_create_empty(num_rows,num_cols,col_prefix,initial_value)

Inputs

ID	Name	Type	Default	Remarks
1	Number of Rows	scalar		Number of Rows
2	Number of Columns	scalar		Number of Columns
3	Col Prefix	scalar		If CSV, the column names will be used as provided
4	Initial Value	scalar		Initial Value

Outputs

ID	Name	Type	Remarks
1	Dataset	dataset

*DATASET_ADD_COLUMN

Description: Dataset Add Column

Syntax: dataset_add_column(dataset,col_name,values)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Name	scalar		Column Name
3	Values	scalar		CSV values one for each now

Outputs

ID	Name	Type	Remarks
1	Dataset	dataset

*DATASET_GET_COLUMN_NAMES

Description: Dataset Get Column Names

Syntax: dataset_get_column_names(dataset_1,search_type,target_value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	search_type	select		Type of search
3	Target	string		Target

Outputs

ID	Name	Type	Remarks
1	dataset_get_column_names_output_1	scalar

*DATASET_EXTEND_ROWS

Description: Dataset Extend Rows

Syntax: dataset_extend_rows(dataset_1,num_rows)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to extend <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Num of Rows	string		Number of rows to extend the dataset using the last row

Outputs

ID	Name	Type	Remarks
1	Extended Dataset	dataset

*DATASET_SORT_BY_KEYVALUE

Description: Dataset Sort By Keyvalue

Syntax: dataset_sort_by_keyvalue(dataset_1,keyvalue_data,primary_key,use_abs_value,order,limit)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Key Value	keyvalue		Sorts the dataset using the value of the keyvalue input <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Primary key	scalar		Primary key for the dataset
4	Choose Abs Value	select		Choose Abs Value
5	Choose Order	select		Choose Order
6	Limit	scalar		Limit

Outputs

ID	Name	Type	Remarks
1	dataset_sort_by_keyvalue_output_1	dataset

*DATASET_SORT_BY_DATASET

Description: Dataset Sort By Dataset

Syntax: dataset_sort_by_dataset(dataset_1,dataset_2,primary_key,sort_column,use_abs_value,order,limit)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	DTBUFS	dataset		Column in this dataset to be used for sorting <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Primary Key	scalar		Column to be used for joining
4	CTUFS	scalar		Column to be used for sorting
5	Choose Abs Value	select		Choose Abs Value
6	Choose Order	select		Choose Order
7	Limit	scalar		If less than zero, a factor of the max-min is used to determine which rows are to be included

Outputs

ID	Name	Type	Remarks
1	dataset_sort_by_dataset_output_1	dataset

*DATASET_FILTER

Description: Dataset Filter

Syntax: dataset_filter(dataset_1,filter)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be filtered <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose filter	filters		Choose filter conditions

Outputs

ID	Name	Type	Remarks
1	dataset_filter_output_1	dataset

*DATASET_RENAME_COLUMNS

Description: Dataset Rename Columns

Syntax: dataset_rename_columns(dataset_1,mapper_input,custom_input)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Mapper	mapper		Mapping definition
3	Custom Map names	textarea		Custom Mapping definition. See <a href=’https://www.d3view.com/docs/master/workflows/Glossary.html#mapdefinitionsinput’ target=’_blank’ class=’btn btn-sm btn-default’> <i class=’fa fa-external-link’> </i> Example </a>

Outputs

ID	Name	Type	Remarks
1	dataset_rename_columns_output_1	dataset

*DATASET_FILTER_BY_COLUMN_DIFF

Description: Dataset Filter By Column Diff

Syntax: dataset_filter_by_column_diff(dataset_1,choose_column,ratio,include_exclude)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Column	textarea		Column to be used for sorting
3	Ratio	textarea		Ratio
4	Include or Exclude	select		Include or Exclude

Outputs

ID	Name	Type	Remarks
1	dataset_filter_by_column_diff_output_1	dataset

*DATASET_SORT_COLUMN_NAMES

Description: Dataset Sort Column Names

Syntax: dataset_sort_column_names(dataset_1,choose_column,regex,order_type)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Columns	textarea		Column to be used for sorting
3	RETCTVFTCN	textarea		_d+ will use all digits following an underscore
4	Choose Order	select		Choose Order

Outputs

ID	Name	Type	Remarks
1	Dataset sorted	dataset

*DATASET_GET_COLUMN_RATIO

Description: Dataset Get Column Ratio

Syntax: dataset_get_column_ratio(dataset1,dataset2,column_name)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3	Column Name	scalar		Column name of the dataset to be checked

Outputs

ID	Name	Type	Remarks
1	dataset_get_column_ratio_output_1	dataset

*DATASET_SET_CONSTANT_VALUE_BY_COLUMN

Description: Dataset Set Constant Value By Column

Syntax: dataset_set_constant_value_by_column(dataset_1,column_name,col_value)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column Name	scalar		Column name of the dataset to be checked
3	New Value	scalar		New Value

Outputs

ID	Name	Type	Remarks
1	dataset_set_constant_value_by_column_output_1	dataset

*DATASET_MERGE

Description: Dataset Merge

Syntax: dataset_merge(dataset1,dataset2)

Inputs

ID	Name	Type	Default	Remarks
1	Source Dataset	dataset		Dataset to be added to <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	DTBA	dataset		Dataset to be added <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	dataset_merge_output_1	dataset

*DATASET_SORT_BY_COLUMN

Description: Dataset Sort By Column

Syntax: dataset_sort_by_column(dataset_1,choose_column,order_type,regex)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Column	textarea		Column to be used for sorting
3	Choose Order	select		Choose Order
4	RETCTVFTCN	textarea		_d+ will use all digits following an underscore

Outputs

ID	Name	Type	Remarks
1	dataset_sort_by_column_output_1	dataset

*DATASET_COLUMNS_TO_CURVES

Description: Dataset Columns To Curves

Syntax: dataset_columns_to_curves(dataset_1,new_col_name,x_point_column,y_point_column)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset with columns	dataset		Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	New Column Name	scalar		New Column Name
3	X Column Prefix	scalar		Column Prefix with X-Points
4	Y Column Prefix	scalar		Column Prefix with Y-Points

Outputs

ID	Name	Type	Remarks
1	dataset_curve_to_columns_output_1	dataset

*DATASET_RECONSTRUCT_BILINEAR_CURVE

Description: Dataset Reconstruct Bilinear Curve

Syntax: dataset_reconstruct_bilinear_curve(dataset_1,new_column_name)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset with columns	dataset		Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	New Column Name	scalar		New Column Name

Outputs

ID	Name	Type	Remarks
1	Datataset	dataset

*DATASET_TRIM_COLUMN_NAMES_AND_VALUES

Description: Dataset Trim Column Names And Values

Syntax: dataset_trim_column_names_and_values(dataset_1)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>

Outputs

ID	Name	Type	Remarks
1	dataset_trim_column_names_and_values_output_1	dataset

*DATASET_ENCODER

Description: Dataset Encoder

Syntax: dataset_encoder(dataset_1,encoder_type,columns,mapper_input)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Encoder Type	select		Encoder Type
3	Columns to Encode	scalar		Columns to Encode
4	Specify Encoding	encoder		Encoding Information for each columns

Outputs

ID	Name	Type	Remarks
1	dataset_encoder_output_1	dataset

*DATASET_REMOVE_UNIQUE_COLUMNS

Description: Dataset Remove Unique Columns

Syntax: dataset_remove_unique_columns(dataset_1,uniqueness_ratio)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Uniqueness Ratio	scalar		Uniqueness Ratio

Outputs

ID	Name	Type	Remarks
1	dataset_remove_unique_columns_output_1	dataset

*DATASET_ADD_COLUMN_BY_REGEXP

Description: Dataset Add Column By Regexp

Syntax: dataset_add_column_by_regexp(dataset,new_column_name,column_name,regexp,index)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	New Column Name	scalar		New Column Name
3	Column for Regex	scalar		Column for Regex
4	Regular Expression	scalar		Ex: (d+)_mm will collect all digits appearing in front of _mm
5	Choose index	scalar		By default it chooses the first occuring pattern

Outputs

ID	Name	Type	Remarks
1	dataset_add_column_by_regexp_output_1	dataset

*DATASET_QUERY

Description: Dataset Query

Syntax: dataset_query(dataset,query,remove_non_alphanumeric)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Query	textarea		You can use column names and C-style syntax as COL1 >= VALUE
3	Remove non-Alphanumeric	select		Remove non-Alphanumeric

Outputs

ID	Name	Type	Remarks
1	dataset_query_output_1	dataset

*DATASET_GROUP_AND_AGGREGATE_BY

Description: Dataset Group And Aggregate By

Syntax: dataset_group_and_aggregate_by(dataset,groupby,aggregateby,aggregation_type)

Inputs

ID	Name	Type	Default	Remarks
1	Choose Dataset	dataset		Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Group by	scalar		Group by
3	Aggregate by	scalar		Aggregate by
4	Aggregation type	select		Aggregation type

Outputs

ID	Name	Type	Remarks
1	dataset_group_and_aggregate_by_output_1	dataset

*DATASET_REPLACE_COLUMN_VALUE_BY_CONDITION

Description: Dataset Replace Column Value By Condition

Syntax: dataset_replace_column_value_by_condition(dataset,columntoreplace,replacements)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column to check	scalar		Column name of the dataset to be checked
3	Replacements	textarea		Conditions using dataset columns such as COL NAME = “abc” => NEW_VALUE

Outputs

ID	Name	Type	Remarks
1	dataset_replace_column_value_by_condition_output_1	dataset

*DATASET_GET_COLUMN_VALUE_BY_CONDITION

Description: Dataset Get Column Value By Condition

Syntax: dataset_get_column_value_by_condition(dataset,columntocheck,conditions,columntoreturn)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column to check	scalar		Column name of the dataset to be checked
3	Conditions	labelcondition		Conditions to be satisfied in order for values to be included
4	Column to return	scalar		Column to return

Outputs

ID	Name	Type	Remarks
1	dataset_get_column_value_by_condition_output_1	scalar

*DATASET_REMOVE_OUTLIERS

Description: Dataset Remove Outliers

Syntax: dataset_remove_outliers(dataset,columnstocheck,num_iterations)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Columns to check	scalar		Column name of the dataset to be checked
3	Number of Iterations	scalar		Number of iterations

Outputs

ID	Name	Type	Remarks
1	dataset_remove_outliers_output_1	dataset

*DATASET_FILTER_COLUMNS_BY_CORRELATION

Description: Dataset Filter Columns By Correlation

Syntax: dataset_filter_columns_by_correlation(dataset,columnstocheck,min_corr,max_corr,targetcolumn)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Columns to check	scalar		Column name of the dataset to be checked
3	Min Correlation Value	scalar		Min Correlation Value
4	Max Correlation Value	scalar		Max Correlation Value
5	Target column	scalar		Target column to check for correlation. If undefined, each columns will be checked

Outputs

ID	Name	Type	Remarks
1	dataset_filter_columns_by_correlation_output_1	dataset

*DATASET_FILTER_CURVE_COLUMN

Description: Dataset Filter Curve Column

Syntax: dataset_filter_curve_column(dataset,columnstocheck,lookup_type,condition,target_value,reverse)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Columns to check	scalar		Column name of the dataset to be checked
3	Lookup Type	select		Lookup Type
4	Condition	select		Condition
5	Target Value	scalar		Value to check. For between the value can be seperated as min:max
6	Reverse matched	select		Reverse matched

Outputs

ID	Name	Type	Remarks
1	dataset_filter_curve_column_o1	dataset

*DATASET_SQL_QUERY

Description: Dataset Sql Query

Syntax: dataset_sql_query(dataset,query,primary_keys)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	SQL Query	textarea		Ex. SELECT MAX(columname) FROM TABLENAME WHERE C2 < 20. It is mandatory to use TABLENAME which will be replaced withe temporary table name
3	Optional Primary Keys	textarea		Optional Primary Keys

Outputs

ID	Name	Type	Remarks
1	dataset_sql_query_output_1	dataset

*DATASET_FORMAT_COLUMN

Description: Dataset Format Column

Syntax: dataset_format_column(dataset_1,column_name,format_string)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column name	scalar		Column name to format. Multiple columns can be provided by using comma as a delimiter
3	Format string	scalar		Format string. Multiple columns can be provided by using comma as a delimiter

Outputs

ID	Name	Type	Remarks
1	dataset_format_column_output_1	dataset

*DATASET_KEEP_COLUMNS

Description: Dataset Keep Columns

Syntax: dataset_keep_columns(dataset_1,column_names_regex)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	CSV column names	scalar		CSV column names

Outputs

ID	Name	Type	Remarks
1	dataset_keep_columns_output_1	dataset

*DATASET_GET_ROW_NEAR_ORIGIN

Description: Dataset Get Row Near Origin

Syntax: dataset_get_row_near_origin(dataset,column_name,num_rows)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset Input <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column name	scalar		Column name to format
3	NORTR	scalar		Positive numbers return values to the right of the smallest while negative will return to the left

Outputs

ID	Name	Type	Remarks
1	dataset_get_row_near_origin_output_1	dataset

*DATASET_CURVE_TO_COLUMNS

Description: Dataset Curve To Columns

Syntax: dataset_curve_to_columns(dataset_1,column_name,num_points,prefix,remove_curve_column,sync_curves,include_x,x_prefix)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset with columns	dataset		Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Curve Column Name	scalar		Column name to format
3	Number of points	scalar		Number of points
4	PFTPC	textarea		Points will be named as PREFIX_ID…
5	RCCAE	select		Remove curve column after extraction
6	Sync Curves	select		Sync curves so all curves have the save x-values with start and ending being the same
7	Include x values	select		Include x values
8	XPFTPC	textarea		Points will be named as PREFIX_ID…

Outputs

ID	Name	Type	Remarks
1	dataset_curve_to_columns_output_1	dataset

*DATASET_CURVE_TO_BILINEAR_COLUMNS

Description: Dataset Curve To Bilinear Columns

Syntax: dataset_curve_to_bilinear_columns(dataset_1,column_name,num_points,prefix,remove_curve_column,sync_curves)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset with columns	dataset		Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Curve Column Name	scalar		Column name to format
3	Number of points	scalar		Number of points
4	PFTPC	textarea		Points will be named as PREFIX_ID…
5	RCCAE	select		Remove curve column after extraction
6	SCSACHTSXWSAEBTS	select		Sync curves so all curves have the save x-values with start and ending being the same

Outputs

ID	Name	Type	Remarks
1	dataset_curve_to_bilinear_columns_output_1	dataset

*DATASET_GET_COLUMN_WITH_NOISE

Description: Dataset Get Column With Noise

Syntax: dataset_get_column_with_noise(dataset_1,column_name,noise_factor)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Column name	scalar		Column name
3	Noise Factor	scalar		Noise factor. Larger number yields smaller noise

Outputs

ID	Name	Type	Remarks
1	Dataset with Noise	dataset

*DATASET_GET_DEFINE_TABLE

Description: Dataset Get Define Table

Syntax: dataset_get_define_table(dataset_1,value_column,curve_column)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Value Column	scalar		Value Column
3	Curve Column	scalar		Curve Column

Outputs

ID	Name	Type	Remarks
1	dataset_get_define_table_output_1	define_table

*DATASET_DIGITIZE_COLUMN

Description: Dataset Digitize Column

Syntax: dataset_digitize_column(dataset_1,column_name,num_points)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset that contains the column to be digitized <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	CCNTNTBD	scalar		Column name to format
3	Digitize Points	scalar		Number of points to digitize

Outputs

ID	Name	Type	Remarks
1	dataset_digitize_column_output_1	dataset

*DATASET_ADD_COLUMN_TRANSFORMING_CURVES

Description: Dataset Add Column Transforming Curves

Syntax: dataset_add_column_transforming_curves(dataset_1,new_column_name)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset that contains the column to be digitized <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	New Column Name	scalar		New Column name to format

Outputs

ID	Name	Type	Remarks
1	dataset_add_column_transforming_curves_output_1	dataset

*DATASET_TO_DOE_PARAMETERS

Description: Dataset To Doe Parameters

Syntax: dataset_to_doe_parameters(dataset_1,columns,dataset_2)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset that contains the column to be digitized <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	Choose Columns	scalar		Columns which are required to be converted to parameters
3	Configuration	dataset		You can specify any additional configurations for each variable as needed in this to overwrite default values

Outputs

ID	Name	Type	Remarks
1	dataset_to_doe_parameters_output_1	dataset

*DATASET_DROP_COLUMNS

Description: Dataset Drop Columns

Syntax: dataset_drop_columns(dataset_1,column_names_regex)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	CSV column names	scalar		CSV column names

Outputs

ID	Name	Type	Remarks
1	dataset_drop_columns_output_1	dataset

*DATASET_COMPUTE_PARETO_FRONT_OPTIMAL

Description: Compute pareto front optimal from provided dataset

Syntax: dataset_compute_pareto_front_optimal(pareto_dataset,columns,criteria,constraints,targets)

Inputs

ID	Name	Type	Default	Remarks
1	NOTD	dataset		Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2	CFTPF	scalar		CSV values are supported
3	Criteria	scalar		Min or Max. Must be equal to the number of cols specified above
4	Constraints	dataset		Constaints to limit the design <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
5	Targets	textarea		Multiple targets can be specified as target1:20,target2:30…

Outputs

ID	Name	Type	Remarks
1	dataset_compute_pareto_front_optimal_output_1	dataset

*DATASET_ADD_COLUMN_FROM_CURVE_LOOKUP

Description: Dataset Add Column From Curve Lookup

Syntax: dataset_add_column_from_curve_lookup(dataset,curve,new_col,start_column,end_column,lookup_type)

Inputs

ID	Name	Type	Default	Remarks
1	Dataset	dataset		Dataset that contains the columns to use as start and end of the curve
2	Curve	vector		Curve whose values are extracted
3	New Column Name	scalar
4	Column that contains the X-Start	scalar		Curve will be clipped between X-START and Y-START specified
5	Column that contains the Y-Start	scalar		Curve will be clipped between X-START and Y-START specified
6	Lookup Type	select

Outputs

ID	Name	Type	Remarks
1	Dataset with new Column	dataset