Forum Discussion

ssmith266's avatar
ssmith266
New Contributor
5 years ago
Solved

SQL Table into Excel File

I have a pipeline that I am working on that requires data to be extracted and transformed in SQL Server (completed) and should be loaded into a single excel file. I cant seem to get my data into an excel file.
Has anyone completed a similar load, if so, how? What snaps and order did you use?

In my research I have seen a lot of articles about excel to DB but not the other way around.

3 Replies

  • ivicakoteski's avatar
    ivicakoteski
    New Contributor III
    2 years ago

    Hi sobha353 ,

    You can parse the string as JSON using the JSON.parse() function in the mapper snap.

     

    JSON.parse($dataDetails.data)

     

    Hence, you can easily map the data as desired.
    Hope this helps!

    BR.
    Ivica