SQL to Dataflux (NOOB)

Vinz867 — Tue, 31 Mar 2020 17:09:34 GMT

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!

Re: SQL to Dataflux (NOOB)

audrey — Wed, 01 Apr 2020 07:25:22 GMT

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

topic Re: SQL to Dataflux (NOOB) in SAS Data Management

SQL to Dataflux (NOOB)

Re: SQL to Dataflux (NOOB)