Difficulty Level: Easy
In this exercise, you will learn how to add ‘hire date’ to the employee list by:
- Validating and previewing data in the pipeline
- Using the Mapper Snap to add fields
- Running a pipeline to obtain lists with added fields
Watch this 3-minute video to learn how to use the Mapper Snap and execute the sample pipeline:
Step 1: Make sure you have copied the sample pipeline (Sample_Pipeline) from the Shared folder within the Pipeline Catalog to your own project folder
Step 2: Click to validate and preview the data in the pipeline. Once the pipeline is validated, the pipeline will turn green, and you can click on the file icon to preview the data.
Step 3: Open the Mapper Snap. In the Input Schema, you should see Hire Date as an unmapped heading.
Step 4: In the Mapping table, click the + to add a row. Add $[‘Hire Date’] to the field in the Expression Column either by dragging it from the Input Schema or manually. The brackets and single quotes are there to maintain the space.
Step 5: Enter a value for the Target Path. To keep it user-readable, use $[‘Hire Date’] again.
Step 6: Click Save and close the dialog.
Step 7: Click on to validate the pipeline. The sample pipeline is ready to be executed, you can click on on the toolbar. The sample pipeline will turn green once it’s successfully executed. Then open the Mapper preview to verify that Hire Date is now available to be sent down to the individual files.
Step 8: Go to the SnapLogic Manager to view the updated files.
Congratulations! You have completed this pipeline exercise!
Need more help?
You can launch the step-by-step exercise and additional resources on the SnapLogic Knowledge Center
Not in the trial but want to try this exercise? Upload this pipeline to your project in SnapLogic.
Sample_Pipeline.slp (23.3 KB)