I have two input columns, which I need to bring together as follows:
Input Column 1 | Input Column 2 | Output Column 1 | Output Column 2 |
A | A1 | A | A1 |
B | A2 | A | A2 |
C | A3 | A | A3 |
B1 | B | B1 | |
B2 | B | B2 | |
B3 | B | B3 | |
C1 | C | C1 | |
C2 | C | C2 | |
C3 | C | C3 |
Can you help me to get this output?
Hi @StuttgartPower - if I am understanding correctly, you should be able to update the value of Input Column 1 using the following function in a Formula tool.
Left([Input Column 2], 1)
Not quite the solution I am looking for. In principle I would like, that it maps certain rows of input-column 2 to certain rows of input-column 1
The exact logic is unclear but @morr-co suggested you should be able to get the expected output using left.
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
Thank you! But what if instead of A, B, C there were completely different terms like Tier3648, Wave375, Fly894, then the workflow would not work, would it?
Sorry i didnt see your previous post.
Are these columns from different data source.
Do you mean that you want to retain the value of Input Column 1 if a value already exists in it? That would look like this:
IIF(IsEmpty([Input Column 1]), Left([Input Column 2], 1), [Input Column 1])
Yes, from different data sources
Excuse me, I have expressed myself far too vague. Hopefully now more clearly. My intention is to get 2 inputs together to one output and to map different lines of input 2 to certain lines of input 1
Input-Data-Source 1
Column 1 |
Tier987 |
Wave285 |
Fly937 |
Input-Data-Source 2
Column 1 |
A1 |
A2 |
A3 |
B1 |
B2 |
B3 |
C1 |
C2 |
C3 |
Output-Data
Column 1 | Column 2 |
Tier987 | A1 |
Tier987 | A2 |
Tier987 | A3 |
Wave285 | B1 |
Wave285 | B2 |
Wave285 | B3 |
Fly937 | C1 |
Fly937 | C2 |
Fly937 | C3 |