This website uses Cookies. By clicking Accept, you agree to the storing of cookies on your device to enhance your community and translation experience. Read our Privacy Policy.
Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Who rated this post

amontminy
L3 Networker

‎09-26-2023 10:30 AM

I would recommend adding a SetGridField automation after ParseExcel to handle mapping the ParseExcel values into the GridField. Here is an example of how I got it to work for a grid field named ExcelData. One thing to note, you will want to reference ParseExcel.[0] since the ParseExcel automation creates an output that is a list so [0] is where your Excel data is located. Also, if you haven't already, I would recommend editing your column headers in the field itself and then make sure to use those new names in the SetGridField automation in the columns input.

Screenshot 2023-09-26 at 10.26.56 AM.pngScreenshot 2023-09-26 at 10.27.09 AM.pngScreenshot 2023-09-26 at 10.27.21 AM.png

View solution in original post

(1)
Who rated this post
LEGAL NOTICES
RESOURCES
Khoros awards 2022
Copyright 2007 - 2024 - Palo Alto Networks