...
| Code Block |
|---|
| language | xml |
|---|
| title | FindConvertAndSave |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
<Query>
<Find>
<VendorInfo>
<vName ne=""/>
</VendorInfo>
</Find>
<SetProcessData key="toCSV.result" value="Name,Title,Location[:EOL:]"/>
<For Each="val" In="Find.Result.VendorInfo">
<SetProcessData key="toCSV.result" Value="[:$ProcessData.toCSV.result:][:$LocalData.val.vName:],[:$LocalData.val.vTitle:],[:$LocalData.val.vLocation:][:EOL:]"/>
</For>
<SaveFile>
<FilePath>
./resources/querydata.csv
</FilePath>
</SaveFile>
</Query> |
| Code Block |
|---|
| language | xml |
|---|
| title | Save Query Output to a File |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
<Query>
<Find>
<VendorInfo>
<vName ne=""/>
</VendorInfo>
</Find>
<SetProcessData key="toCSV.result" value="Name,Title,Location[:EOL:]"/>
<For Each="val" In="Find.Result.VendorInfo">
<SetProcessData key="toCSV.result" Value="[:$ProcessData.toCSV.result:][:$LocalData.val.vName:],[:$LocalData.val.vTitle:],[:$LocalData.val.vLocation:][:EOL:]"/>
</For>
<SetLocalData key="FILE" value="#o'resources/querydata.csv'#"/>
<Log>[:[:$LocalData.FILE:][:$ProcessData.toCSV.result:]:]</Log>
</Query> |
Finally to View the file:
...