Hello Everybody!
I´m using Dataflux DMStudio 2.6 to read those values below:
"asString";"asInteger"
"A001127209";"A001127209"
"000379043B";"000379043B"
"00085351C6";"00085351C6"
"0014479443";"0014479443"
Case A. Reading from a txt file containing that lines:
I read the first column (Field Name asString) as an STRING(10) field type, and the second column as an INTEGER(10) field type.
In that case, when I preview the data the results are:
1 - Generates a "0" result;
2 - Preserve only the left significative numeric characters (379043),
3 - Preserve only the left significative numeric characters (85351),
4 - Preserve only the left significative numeric characters, in that case, the real value.
Case B. Reading as a Job Specific Data:
In that case, when I preview the data the results are:
1 - Generates a "null" result;
2 - Preserve only the left significative numeric characters (379043),
3 - Preserve only the left significative numeric characters (85351),
4 - Preserve only the left significative numeric characters, in that case, the real value.
So, I´d like to understand:
a) Why Dataflux accepts an alphanumeric value (even part of it) as a input of an Integer field?
b) Why not treat all alphanumeric strings as "null" results?
c) Why Dataflux treats the first string in different ways when reading a file and for Job Specific Data ( "0" x "null" )?
d) Where can I find documentation for content transformation between different field types?
I welcome any information that helps to clarify this situation.
Thank you all.
Luís Leite
Luis,what you have identified is unfortunately some disparate behaviour between these two components. It would be good if they behaved the same, but unfortunately they do not. The text file node will read until the first non-numeric character, and the job specific data will issue null if it finds a non-numeric value. It's possible that this will be fixed in a future version.
Ok Andrew!!
Would you know where can I find any kind of documentation about this flield type transformation?
i.e. between Integer, Strings, Real, Boolean, etc...
Thank´s a lot!
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 16. 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.