Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Cloud Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED
I need help to get started based on dummy data below
when specific name is spot. I will need to create a new few lines on the facility code with the rest of the columns with same value. Please see below image
| Facility Code | Facility Code |
| 01-01-HALL | 01-01-0001 |
| 01-01-0002 | |
| 01-01-0003 | |
| 01-01-0004 | |
| 03-01-HALL | 03-01-001A |
| 03-01-001B | |
| 03-01-001C | |
| 02-02-HALL | 02-02-000A |
| 02-02-000B | |
| 02-02-000C | |
| 02-02-000D | |
| 02-02-000E |
Solved! Go to Solution.
@XXX_Rosy_XXX
just join tool will do. but you need to adjust the vlookup table (as screenshot below, suggest to remove blank row because it may impact the result).
Join Tool will generate duplicate if there have more matched record.
