Q&A BY TAG 'Formula'

You must sign in to ask a question. If you do not have an account, you can register here

Interpolation Variable using a formula - Julian calendar date
answered 06-04-2022 09:07:18 -0400

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

Answers: 1

Formula Interpolation Variables Date time function

Dynamic Path for Custom S3 Wrapper
answered 31-08-2021 09:05:29 -0400

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

Answers: 2

Formula Dynamic CSV AWS S3 Distributed File System Custom Wrapper

RegexExp to extract value between parentheses
answered 28-09-2020 02:55:22 -0400

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, '/(([^)]+)...

Answers: 1

Formula Regex

Evaluate a formula present in a text field
answered 26-05-2016 11:05:56 -0400

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

Answers: 1

Formula View