Transform Syntax in Workbench 4.5

MattE_SC
MattE_SC Member
in Archive

I'm not an SQL expression expert but I feel like I shouldn't be having this much difficulty creating a transform in the calculation builder of Workbench.  (I'm very proficient with Beast Mode syntax, but I realize this is different)

 

I want to take a string (type) column and only use the first 6 characters from the data.

Attempting to use the MID function and the example, I have tried:

 

MID(`Pkg_Reference_1`,1,6)  and various variations.  

 

I've even tried testing syntax with more basic SUM or formating functions and every time I get the failure reason of "unexpected  identifier at character 6".  The character number will vary but is always the ` (backtick) character that  starts out the column name.

I am either failing misearably at understanding the syntax required or there is an issue with tranforms in WB 4.5 that is causing them all to fail, because I can't get a single one to work. 

 

Any guidance please...

 

 

Comments

  • AS
    AS Coach
    You probably just need to drop the backticks. Even though Beast Mode uses them they aren't necessary in WB transforms.
    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • keithhickman07
    keithhickman07 Member
    Try:

    TRIM(SUBSTR(t5.ADDR_ZIP,0,5))

    Where 0 is the start and 5 is the stop for extracting your string.
This discussion has been closed.

Categories