Hi All,
I am new to Alteryx. I am trying to create a workflow that adds descriptions as sub-headers to SAP technical names in a report.
Any support will be appreciated. thanks! For example, I have 2 Excel files
The first File contains the SAP report with technical names:
| LIFNR | NAME1 | ORT01 | LAND 1 |
| 0 | A | Berlin | Germany |
| 1 | B | Berlin | Germany |
| 2 | C | Berlin | Germany |
| 3 | D | Berlin | Germany |
The second file contains technical names and their descriptions:
| Field | Description |
| LIFNR | Account Number of Vendor or Creditor |
| NAME1 | Name 1 |
| ORT01 | City |
| ALC | Agency Location Code |
| LAND1 | Country Key |
| ANRED | Title |
Desired Output:
| LIFNR | NAME1 | ORT01 | LAND1 |
| Account Number of Vendor or Creditor | Name 1 | City | Country Key |
| 0 | A | Berlin | Germany |
| 1 | B | Berlin | Germany |
| 2 | C | Berlin | Germany |
| 3 | D | Berlin | Germany |
I am trying to create a work flow that will search through the description list and only pull out the description that applies to the report.
