Hi Team, I have 2 excel files, one with 10 fields and other with 5 fields. I want to not join but map these 2 excel fields and add the columns in total 15 in a single excel mapped. Column Table Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10518848478379202613388920633314632795884593437204114484240947729658064938569359196216913994682365362285166428568 Select Table Select1Select2Select3Select4Select577221912773120659443977704973892022101364395543634194451854831708871868828 Map logic : Column 3 = Select 3 Output : Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10Select1Select2Select3Select4Select5518848478379202613518548317038892063331463279573120659488459343720411448427389202240947729658064938564397770499359196216913994682772219127365362285166428568101364395 Please advise.

Mapping 2 excel files

Hi Team,

I have 2 excel files, one with 10 fields and other with 5 fields.

I want to not join but map these 2 excel fields and add the columns in total 15 in a single excel mapped.

Column Table

Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10
51	88	48	47	83	79	20	2	6	13
38	89	20	6	33	31	4	63	27	95
88	45	9	34	37	20	41	14	48	42
40	94	77	29	65	80	64	93	8	56
93	59	19	62	1	69	13	99	46	82
3	65	36	22	85	1	66	42	85	68

Select Table

Select1	Select2	Select3	Select4	Select5
77	22	19	12	7
7	31	20	65	94
4	39	77	70	49
7	38	9	20	22
10	1	36	43	95
54	36	34	19	44
51	85	48	31	70
88	71	86	88	28

Map logic : Column 3 = Select 3

Output :

Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Select1	Select2	Select3	Select4	Select5
51	88	48	47	83	79	20	2	6	13	51	85	48	31	70
38	89	20	6	33	31	4	63	27	95	7	31	20	65	94
88	45	9	34	37	20	41	14	48	42	7	38	9	20	22
40	94	77	29	65	80	64	93	8	56	4	39	77	70	49
93	59	19	62	1	69	13	99	46	82	77	22	19	12	7
3	65	36	22	85	1	66	42	85	68	10	1	36	43	95

Please advise.

Developer

Output

Common Use Cases

Accepted answers

IR_2021

That is exactly the output from this?

All comments

IR_2021

Hey,

I hope this will work for you

Mapping 2 excel files.yxmd

JDong

@IR_2021 Thanks.I want to map on "Column3 = Select3" and then append the files. Also when I append it would show more number of rows.

How can I achieve that?

IR_2021

Hey, I hope I understand correctly that is it this?

Mapping 2 excel files.yxmd

JDong

@IR_2021 Sorry maybe my data was not a good sample. Tried to describe my question better.

It should lookup between the table values between Column2 and Select3 and then append. I want to ideally display all the records from only the left "Column table"

IR_2021

That is exactly the output from this?

JDong

@IR_2021 Thanks but I get a variation with the data in my actual dataset. The join pulls more than needed records and the expected value is not seen. Anyway to overcome this issue?

IR_2021

@JDong If you want to link 2 files in this way, the values in Column3 and Select3 must be unique. If this is not the case, more lines will be output than with the original files. If double lines are the same you can use the "unique tool". This tool wil filter unique lines based on select fields in the dataset.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703