Latest Activity


Interpolation Variable using a formula - Julian calendar date

I have a data source which requres a dynanmic file name to be reference using a Julian date - last two digits of the year and the current day number. So 2022-04-04 would be 22094. Is there an easy way to include this value as part of the interpolatio...

Formula Interpolation Variables Date time function


Dynamic Path for Custom S3 Wrapper

I have a backup file that is time stamped like this each day: GDW_08-30-2021.csv The current path to reference this file in the custom wrapper via AWS S3... looks like this: /gdw_backup/GDW_08-30-2021.csv is there a way to embed a caclulated value ...

Formula Dynamic CSV AWS S3 Distributed File System Custom Wrapper


RegexExp to extract value between parentheses

I am trying to use the following formula to return the value that is between parentheses in a field. For some reason it is just returning the exact same value. I am pretty sure this REGEX is valid. regexp(bv_epic_tpi_inventory_report.hcco, '/(([^)]+)...

Formula Regex


Evaluate a formula present in a text field

I have a table where I have a formula as a text attribute. I want to query this table and get an output with an addition derived attribute where I want to capture the execution result of the formula. Sample in input data : Select 1 Num,'0+ 1(3)' Exp...

Formula View