Merge two columns of different size

[StuttgartPower]

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?

[morr-co]

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)

[StuttgartPower]

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

[atcodedog05]

Hi @StuttgartPower 

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

[StuttgartPower]

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?

[atcodedog05]

Hi @StuttgartPower 

Sorry i didnt see your previous post.

Are these columns from different data source. 

[morr-co]

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])

[StuttgartPower]

Yes, from different data sources

[morr-co]

I just saw your updated example. I've attached a way that you could extract the leading alpha characters with a regex tool.

[StuttgartPower]

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