SQL in ETL

damen · 2023-03-24T19:14:00+00:00

There was an error rendering this rich post.

damen

Hi All,

I'm currently trying to recreate a MySQL flow in Domo to ETL.

One of the first things we are doing in a table is taking out extra characters from a column to create a new trade_id

Here is how we are doing it.

when I go to add the formula tile and copy and paste this syntax, ETL is saying it doesnt recognize the 'LOCATE' function.

So keeping the same framework of finding the '%G2%' (for example) and taking everything from the left of those characters we have designated, is there a similar function that ETL will recognize? If so, what would one of the lines look like?

TIA

Find more posts tagged with

SQL

Magic ETL

Beast Mode

Accepted answers

All comments

MarkSnodgrass

I use the INSTR() function for this type of work.

INSTR(STR,SUBSTR)Returns the position of the first occurrence of substring substr in string str.

damen

Ok so I went in and did this

and got this

but am looking for this

It feels like the error is in my syntax.

@MarkSnodgrass

MarkSnodgrass

Unfortunately, it looks like INSTR and LOCATE have their arguments reversed. For INSTR() it needs to be INSTR(trailid,'G2'), for example.

damen

Sheesh. Thanks @MarkSnodgrass!!