Subject:Need help with using XQuery in Stylus Studio to convert and transform flat file to xml Author:Dwayne Bordelon Date:17 Apr 2009 09:34 AM
I have a tilde delimited file that I need to convert to an xml file. I have the initial conversion step done(an exact representation, just in xml) and some of the more complicated conversion(representing the 1 to many relationships) done with xquery. I am stuck with removing duplicates. The source file(tilde delimited) can have repeating rows of customer information because there are two levels of information in the file. I am getting a result with the right representation, but I cannot keep it from repeating the customer info based on how many times it shows up in source file.