SQL to Dataflux (NOOB)

[Vinz867]

Hi,

I need some help converting this SQL to a Dataflux expression. I am trying to do a comparison between 2 files and old code in SQL used this to compare it. 

LEFT(LTRIM(RTRIM(cast(COLUMNA as varchar(1000)))),LEN(COLUMNB)) = COLUMNA

LEFT(LTRIM(RTRIM(SUBSTRING( LTRIM(RTRIM(CAST(COLUMNA as varchar(1000)))) , LEN(COLUMNC) + 1  ,LEN(cast(COLUMNA as varchar(1000)))-  (LEN(@COLUMNC) + 1)  ))),LEN(COLUMNB) = COLUMNA

Column A is from  File A

Column B is from File B.

Column C is from File B.

Please help!

[audrey · Accepted solution]

Hello,

Did you try to use the Expression node? The left, len and trim function exist, which could be reused pretty much identically.

What is the type of ColumnA in input? Does it need to be changed to a varchar?

• If not, you can use something like: `ColumnA` = LEFT(TRIM(`ColumnA`),LEN(`ColumnB`))
• Otherwise, you might want to add a tostring function: `ColumnA` = LEFT(TRIM(tostring(`ColumnA`)),LEN(`ColumnB`))

For the second line, only the substring function doesn't exist, it can be replaced by a combination of LEFT and RIGHT.

Hope this helps. If you need a more detailed help, do not hesitate to reach out to support.

Thanks,

Audrey