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 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