Transform flat datatable to dataset using xsd

Tetak

New Member
Can anyone advise me if this is possible?I have data in textform that looks like this:...^GLOBAL HDORDNOLBL^GLOBAL HDORDNO^GLOBAL ORDDATLBLOrderdatum^GLOBAL ORDDAT01/06/12^GLOBAL INVDATLBLFact.datum^GLOBAL INVDAT05/06/12^GLOBAL COUNTRYLBL^GLOBAL COUNTRYBelgium^GLOBAL CUSNOLBLKlantennummer^GLOBAL CUSNOAL8985...I'll be putting this in a flat datatable with ^[ITEM] being a field and [VALUE] being the value. I can manage this BUT... I would like to transform this datatable to a dataset based on certain rules. Basically what i want to do is make a structured dataset from flat data. What is the best way to get around?Thank you!
 
Back
Top