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!
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?
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
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?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.