Arrays walkthrough
- Topics:
- Workfront Fusion
CREATED FOR:
- Beginner
- User
Review previous walkthrough exercises where simple and complex arrays were used. We’ll review how we found these and how to utilize the information using array functions if necessary.
Arrays walkthrough
Workfront recommends watching the exercise walkthrough video before trying to recreate the exercise in your own environment.
Transcript
The purpose of the next walkthrough exercise, is to return to two scenarios where we already have worked with simple and complex arrays. In the creating and using data structures walkthrough exercise, we use the split array function to get values out of the simple array key.
In our, Creating different paths using routers, where we call the Pokemon and the superhero, APIs, the output for the returned information was a complex array or a combination of arrays, collections and elements or items.
To be successful at following along in the next walkthrough training videos, you’ll want to have both of these scenarios pulled up and ready to run them once again.
To take a look at a simple array, I’m going to return to our, Creating & Using Data Structure scenario. The first thing I’ll do once I’m in the scenario, is rerun it.
After it runs, I’m going to click into the execution inspector on our numeric aggregator and scroll down to the output section.
Here I can see that each bundle produced from parsing our original CSV, has both a Result and a Key. The key is made up of a user email and a date, comma separated.
If you remember when we went through this walkthrough exercise, to create a new CSV using our data structure, we actually had to take that key produced by our numeric aggregator and split the information. We had to use the split array function because that key contained two different elements that we wanted to grab individually. And because of how we parsed our CSV and iterated through the information, you can consider the iterated information from our parsed CSV to be our simple array. It’s simply a list of individual items. Our key however, is a combination of two items, the email and the date. So we have a variable list of emails and dates that we then want to split to get the email out of it for our user ID and the date out of it for our date column. This is an example of a simple array, single individual items. In the next video, we’ll highlight how a complex array will have more of a data structure to it. And it will vary depending on the number of index structures within that array.
To review a complex array, I’ll return to my, Creating different paths using routers scenario. Again, I’ll start by rerunning this scenario so we can see information in our execution inspectors.
Once it finishes running, I’ll go up and click on the execution inspector on our, Get Pokemon API module.
Here we can see that nine operations were run or nine bundles were passed down this path. If I go into one operation and look at the output, I can see that the data itself coming from the Pokemon API is listed as a collection. If I click into that collection, I then can see a structure of arrays or elements and even additional collections.
Expanding the abilities array for the first set of data, I can see that there are two collections and within these two collections there is yet another collection, for the ability and two elements hidden, equals false in slot number one.
If I drill down into the final collection, I can see the name of the URL for each ability for the Pokemon that came with this bundled output. If I get out of this execution inspector and go into the variables after our, Get Pokemon API call, you’ll remember that we mapped over some individual elements or items from the API call. But then we had to use the Map array function to get the ability’s name out of the array, giving us multiple ability names, depending on the number of indexed abilities for each character.
You may have also tried the practice exercise where you had to get the six different stats and the level for each stat into an additional variable.
At that point in the training you may have come into the item list for the data selection, gone into the stats selection and chose the stat name.
When you do this, the stats are an array themselves and the index of that first item, is one. You could have followed that with a parentheses and gotten the base stat for the value for that first stat name and continued to hit return and grabbing the stat name but changing the index number, from one to two.
This would only work if the array had a set of variables you were aware of. But when it’s a variable number of variables, meaning you don’t know how many different stats might be returned, zero to many. This is where iteration comes into play and you can iterate through the stat name and the base stat number and then aggregate that information and put that information into the stat variable. -
Want to learn more? We recommend the following:
Workfront
- Workfront Tutorials
- Administration and Setup
- Organizational setup
- Manage deleted items
- Configure system defaults
- Layout templates
- What are layout templates?
- Find layout templates
- Customize terminology with layout templates
- Customize the Main Menu with layout templates
- Add and manage pins through a layout template
- Customize Home with layout templates
- Assign and manage access to layout templates
- Customize object areas with a layout template
- Customize project details with layout templates
- Customize project headers with layout templates
- Customize reporting lists with layout templates
- Email and In App Notifications
- Create and manage users
- Approval processes and milestone paths
- System performance and maintenance
- Project finances
- Custom Data
- Custom Forms
- Calculated expressions
- Get started with calculated fields and expressions
- Learn the data expression structure
- Understand Date & Time and Mathematical expressions
- Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions
- Use the Calculation Editor
- Create DATEDIFF and WEEKDAYDIFF expressions
- Create a SUB, SUM, DIV, or PROD data expression
- Use the CONCAT expression in a calculated field
- Create LEFT/RIGHT expressions
- Use the ISBLANK and CONTAINS expressions
- Create an IF text expression
- Things to know about calculated field expressions
- Manage work
- Projects
- Understand basic project creation
- Navigate the project page
- Learn four ways to create a project
- Fill in the project details
- Get started planning a project
- Take a project live
- Get started managing a project
- Find projects
- Share a project
- Understand the project team
- Understand project communication
- View project information
- Track overall project progress
- Track work progress with project metrics
- Understand the Gantt view
- Understand the Board view
- Tasks
- Issues/requests
- Request queues
- Portfolios
- Approval processes and milestone paths
- Create and manage project templates
- Project timelines
- Close a project
- Project finances for users
- Intermediate projects
- Projects
- Reporting
- Basic reporting
- Understand reporting elements
- Understand reporting components
- Create a basic grouping
- Create a basic view
- Add basic conditional formatting to a view
- Create a basic filter
- Understand the new filter experience
- Create basic filter activities
- Create a simple report
- Create a task report
- Copy a report
- Create reports with charts
- Create a matrix report
- Create dashboards
- Send and share reports
- Understand report settings
- Intermediate reporting
- Create filters with user-based wildcards
- Create filters with date-based wildcards
- Create OR statements in filters
- Understand built-in project filters
- Understand built-in task filters
- Understand built-in issue filters
- Understand basic text mode for filters
- Understand basic text mode for views
- Understand basic text mode for groupings
- Create custom prompts
- Advanced reporting
- Calendar reports
- Basic reporting
- Manage resources
- Workfront Goals
- Workfront Planning
- Integrations
- Adobe Creative Cloud
- Adobe Experience Manager Assets Essentials
- G Suite
- Jira
- Microsoft Outlook
- Microsoft Teams
- Adobe Workfront for Microsoft Teams Overview
- Install Adobe Workfront for Microsoft Teams
- Access Adobe Workfront from Microsoft Teams
- Search for and share Adobe Workfront items in Microsoft Teams
- Create Adobe Workfront tasks from Microsoft Teams
- Submit Adobe Workfront requests from Microsoft Teams
- Manage Adobe Workfront notifications in Microsoft Teams
- Slack
- Fusion
- Welcome to Workfront Fusion
- Understand the basics
- Initial scenario design walkthrough
- Initial scenario design exercise
- Mapping panel and formula editor
- Mapping panel important notes
- Beyond basic mapping walkthrough
- Beyond basic mapping exercise
- Use filters
- Filters walkthrough
- Filters exercise
- Access previous versions walkthrough
- Access previous versions exercise
- Universal connectors and routing
- Universal connectors exercise overview
- Introduction to universal connectors walkthrough
- Introduction to universal connectors exercise
- Understand routers
- Routers walkthrough
- Routers exercise
- Common routing patterns
- Routing patterns walkthrough
- Routing patterns exercise
- Set-it and get-it
- Get/Set variables walkthrough
- Set/Get variables exercise
- Iteration and aggregation
- Execution history and scheduling
- Beyond basic modules
- Data structures and data stores
- Final functional bits and bobs
- Troubleshooting and error handling
- Workfront Fusion administration
- Design optimization and testing
- Workfront Proof
- Learn the benefits of proofing
- Understand the difference between a document and a proof
- Proofing viewers explained
- Administration and setup
- What is an automated workflow template
- Customize proof comment actions
- Customize proof decision options
- Understand email alerts and proof notifications
- Proof roles and email alerts
- Report on proofs
- Set default at risk proof settings
- Set up global proof settings
- Set default proof roles
- Set up proof account default settings
- Settings for proof users
- Upload proofs
- What is a proof version
- Who uploads the proof versions
- Convert a document to a proof
- View and compare proof versions
- Upload a proof version
- Manage proof versions
- Upload a proof of a video
- Upload a proof of a website
- Upload a proof with a basic workflow
- Upload a proof with an automated workflow
- Upload with a drag and drop
- Combine multiple files into a single proof
- Proof workflows
- Review and approve work
- Workfront DAM
- System setup
- Metadata and keywords
- Brand Connect customization
- Workfront DAM user: Contributor
- Understand Workfront DAM as a contributor
- Understand asset management as a contributor
- Understand finding assets as a contributor
- Understand lightboxes as a contributor
- Understand metadata and keyword best practices
- Work with assets as a contributor
- Send a file as a contributor
- Publish assets as a contributor
- Add a Workfront DAM link
- Brand Connect user
- Home
- Agile
- Best Practices
- Agile
- API Explorer
- Business case and portfolio optimizer
- Communication
- Custom forms
- Custom reports
- Dashboards
- Documents
- Filters, views, and groupings
- Job roles
- Layout templates
- Licenses and access levels
- Onboarding and adoption
- Organization units
- Portfolios and programs
- Preview sandbox
- Project, task, and issue preferences
- Project templates
- Proofing
- Request queue
- Resource Planner
- Resource pools
- Scenario Planner
- Schedules
- Statuses
- System performance and maintenance
- Text mode reporting
- Timeline planning and management
- Timesheets and logging time
- Utilization
- Workfront Goals
- Workload Balancer
- Workfront for executives