Forum Discussion
Reading dictionary type
I am using below sql to get validation messages from the workflow transformation process to be used in Transformation Event Handler. But, I need to put the output of this dictionary into a flat file...
Henning
OneStream Employee
OneStream EmployeeHi, how about instead of writing the results into a dictionary, use your existing data table (dtValidation) and save it as a CSV directly.
This post should get you where you want to be:
Solved: Saving an export directly to the shared folder - OneStream Community (onestreamsoftware.com)
I agree, if you can do this during your initial for loop then it would save doing more potentially redundant looping down the track.
I would also suggest including more detail in your code to at least show the definition of the variable that you're asking about.
It looks like your dictionary contains a list of strings for each key. I would strongly advise doing it in your datarow loop but here is some generic VB.net code that could have assisted if that option was not available:
' Specify the file path for the CSV file Dim filePath As String = "errorOutput.csv" ' Generate CSV output Using writer As New StreamWriter(filePath) ' Write the header (optional) writer.WriteLine("Error Code,Description") ' Iterate through the dictionary For Each kvp As KeyValuePair(Of String, List(Of String)) In errorDict Dim key As String = kvp.Key For Each value As String In kvp.Value ' Write the key and value to the CSV file writer.WriteLine($"{key},{value}") Next Next End Using
