Hi,
I've got these data:
And I need to import them to one item. Each row has to be imported to a specific item field.
I know this won't be searchable, but it's way easier to explain it in a video: http://screencast.com/t/MDZ6TsT9
Hi,
I've got these data:
And I need to import them to one item. Each row has to be imported to a specific item field.
I know this won't be searchable, but it's way easier to explain it in a video: http://screencast.com/t/MDZ6TsT9
Option 1: Did you try to create a separate import job for each "Logger"?
Option 2: Use SQL Server to pivot the data (turn rows into columns)
You can do this by following these steps.
Example of how to pivot the data in SQL Server (change as needed):
SELECT [29020] AS Logger1, [29032] AS Logger2, [29044] AS Logger3, [29056] AS Logger4, [29068] AS Logger5, [29080] AS Logger6, [29092] AS Logger7 FROM Loggers PIVOT (SUM([Value]) FOR [ID] IN ([29020], [29032], [29044], [29056], [29068], [29080], [29092])) AS PivotTable;
Option 3: Transform into XML and use XSLT to pivot the data
You must be logged in to post in the forum