I have two input columns, which I need to bring together as follows: Input Column 1Input Column 2Output Column 1Output Column 2AA1AA1B A2AA2CA3AA3 B1BB1 B2BB2 B3BB3 C1CC1 C2CC2 C3CC3 Can you help me to get this output?

@atcodedog05 I did as well, but after reading that your suggestion did not do the trick, I think it might be something else 🙂

I think this may get you what you need. It is predicated on joining by record position which isn't a great practice in my opinion. I would recommend reviewing the results of your entire data set before implementing this. joins.yxmd

@Per great point. I just assumed its the sequence.

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?

Output

Tips and Tricks

Power BI

Accepted answers

All comments

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

same length.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703