cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
matt_w
‎09-01-2015
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: XML and DI Studio

by Obsidian | Level 7 in SAS Data Management
‎01-24-2019 07:57 PM
‎01-24-2019 07:57 PM
I didn't write any code at all. XML Mapper auto generates the XML Map file for your XML file, as along structure is same there is no need to touch the XML map.   DI Studio represents that XML file as table in metadata and use Table loader to load into SQL Server directly. No code.    I do not have experience in Talend but I believe it is similar except Map file is generated inside the Talend tool. when XML file structure changes then you still need readjust the XML Map transformation according to new structure in Talend . ... View more

Variable names in DI studio

by Calcite | Level 5 in SAS Data Management
‎09-02-2011 07:33 AM
‎09-02-2011 07:33 AM
Hi I ended up raising a track with SAS as I wasn't getting anywhere - think this is down to my lack of previous SAS coding experience, a more experienced user may have found this problem much more quickly. Turns out there's a bug in the version I'm using (4.21) which incorrectly generates the header rows in the file writer transformation. This is addressed by going into the file writer and amending the section of code which generates the header. From this:    if ( _n_ = 1 ) then          do;             put incorrect ->  ""Org"n,"_101"n,"_102"n";          end; To this:        if ( _n_ = 1 ) then          do;             put correct ->   "Org,_101,_102";          end; And once I've changed this bit of code I'm able to remove the leading underscores and export in my desired format! SAS tell me this bug is fixed in version 4.3. Matt ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links