Mapping 2 excel files

[JDong]

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.

[IR_2021]

Hey,

I hope this will work for you

[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?

[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 · Accepted solution]

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.