Hi, i am trying to convert column in table 1 to row in table 2. Table1: Header1Header2ABABCDACACDEADADEFAEAEFGAFAFGH Table2: ABACADAEAFABCDACDEADEFAEFGAFGH Also, after i get the output of table2 i would like to find a matching row in another file with multiple rows of similar data. Thanks for your help in advance.

How to convert column to a row?

Hi, i am trying to convert column in table 1 to row in table 2.

Table1:

Header1	Header2
AB	ABCD
AC	ACDE
AD	ADEF
AE	AEFG
AF	AFGH

Table2:

AB	AC	AD	AE	AF
ABCD	ACDE	ADEF	AEFG	AFGH

Also, after i get the output of table2 i would like to find a matching row in another file with multiple rows of similar data.

Thanks for your help in advance.

Common Use Cases

Best Practices

Accepted answers

T_Willins

Hi @vmadyala,

Part one is done with a Cross Tab tool. Part two is done with a Join tool configured to match on all columns that should be the same in both files.

cross tab and join.png

cross tab and join.yxmd

All comments

T_Willins

Hi @vmadyala,

Part one is done with a Cross Tab tool. Part two is done with a Join tool configured to match on all columns that should be the same in both files.

cross tab and join.png

cross tab and join.yxmd

vmadyala

Thanks for the help. Part1 is fine. However, with part2 my columns are different in another file and there are many columns to compare. so, it would be tedious to select each column in join function. I would like to find a close or exact match to part1 output in the other file. Hope you can assist.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335