Bots From Extension: cfxaia
CloudFabrix AIA
This extension provides 2 bots.
Bot @cfxaia:conditional-statement
Bot Position In Pipeline: Sink
Performs simple if-else condition on input dataframe columns
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
Parameter Name | Type | Default Value | Description |
---|---|---|---|
condition_column* | Text | Specify comma separated columns to check (ex: A,B), atmost 2 columns can be specified | |
operator | Text | Supports the logical, identity & membership operators ex:[=,>=,<=,!=,<,>,notin,in,is,is not,contains], by default checks if values in condition_col is not None |
|
check_value | Text | False | Enable if condition_column need to check the value |
value | Text | Specify the comma separated values that need to check in the condition column ex: if A,B are condition_cols & a,b are values, A is combared with value a & B is compared with value b |
|
return_if | Text | Return column_name/value if condition satisy,by Default returns None | |
return_else | Text | Return column_name/value if condition does not satisfy,by Default returns None | |
to_column | Text | Specify to column name to which values need to be returned,by Default values will be returned to 1st condition_column if not specified |
|
replace_if_null | Text | False | If enabled, return column will be replaced with value based on condition only if condition_column is None |
Bot @cfxaia:por-projection
Bot Position In Pipeline: Source
por-projection
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
Parameter Name | Type | Default Value | Description |
---|---|---|---|
org_id* | Text | org_id of the customer | |
assetLCMMaster_location | Text | False | AssetLCMMaster.csv file location |
location_to_save | Text | False | Location to save POR_Replacement_Projection.csv file |