There are two options available when creating a new XML document. The NEXTINT() function returns a number for each row, incrementing the value by 1 each time it is called.įor more examples of the functions you can use with calculated columns please see our documentation pages. You can then enter in a function to decorate the data. To do this click onto the fx button in the data source toolbar and then enter in a unique name for the column and set the data type. If your data does not currently have an ID column that can be used to uniquely identify each record, then you can use calculated columns to create one.Ĭalculated columns enable you to decorate your dataset with additional data. The new XML document nodes/columns will be created based upon what is included in the schema map. Make sure to include a key column that can be used to uniquely identify each record. Add the Columns to the Schema Mapīefore creating the new XML document you need to add the columns you want to include and create in the table to the schema map.īy default all the columns will be added but you can remove and re-order the columns as you need to. You can do this either by dragging and dropping the CSV from the file explorer onto your source, or by clicking onto Connect Datasource > Text Files > CSV File and then browsing for your CSV by clicking onto the ellipsis in the FileName field.Ĭlick Connect to load the file into your source window. Start by opening Data Sync and connecting to your CSV file.

If you do not have Data Synchronisation Studio you can get a free evaluation edition.

Downloaded & Installed Data Synchronisation Studio (minimum version ).

Before getting started you need to ensure you have the following:

Xml convert to csv