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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.