Skip to content

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