This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Dynamic file name in excel format

ankita1212
New Contributor

โ€Ž07-09-2021 01:44 PM

I want to name a file dynamically while creating an excel, the csv formatter allows dynamic file naming but not the excel formatter. I am having issues with the csv formatter, it does name the file dynamically but the csv file does not show all fields queries from Salesforce. Any suggestions how so I proceed?

0 Kudos
1 REPLY 1

skatpally
Former Employee

โ€Ž07-09-2021 04:03 PM

Am assuming that field names are missing ? You can work your way around it so that all the fields come in the first record. You can do a Groupby and then sort it through an expression.

Below is the known limitation on the snap.

  • The Snap prepares the column header for the output view (and hence the CSV file) using the keys defined in the first record. This may result in ignoring any additional key passed in the subsequent records. We recommend that you pass values for a comprehensive set of all keys used in the input view, for the first record.
0 Kudos