Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Write Files to Local Drive

@jskrable: I’m fairly new to snapLogic and wanting to export the files directly to my local system (i.e. C drive), how can I accomplish this? Sharing some snaps below for everyone’s reference: ...
jcornelius's avatar
jcornelius
New Contributor III
4 years ago

@Damone
do it all in SQL
ie
IF EXIST(Select id from table_x where id=@id)
BEGIN
UPDATE table_x set col1=@col1 where id=@id
END
ELSE
BEGIN
INSERT INTO into table_x (id,col1) values(@id,@col1)
END

  • cjhoward18's avatar
    cjhoward18
    Employee
    4 years ago

    Hi @jsmith141

    Since the specification is stored as a JSON object there is no guarantee on the order of the keys displayed, and we do not have a way to customize the order displayed at the moment.

    • jsmith141's avatar
      jsmith141
      New Contributor III
      4 years ago

      Hi @cjhoward18,

      Thanks for the reply. That is kinda what I figured was happening. Do you happen to know if controlling the order of the keys being displayed may be something that is possible in a future update, or is it on the list to be added as a product enhancement?

      Thanks again