Find unique values in each field

I am new to Alteryx, and would need to find unique values in each column within a spreadsheet. I can do a individual unique over each column but my spreadsheet has 70 odd columns and was wondering if there is way to iterate through columns and do unique over each column.

Please also suggest if there is any other suitable tool to achieve this.

Common Use Cases

Accepted answers

MarqueeCrew

To convert back to rows:

Cross Tab with name as header and value as value.

I think that it will produce what you’re asking for? In what was produced originally it is a list of unique values by field. If you use a key, then you can produce unique values by that key.

All comments

MarqueeCrew

If you transpose the data first, you will get name value pairs. Only select the fields that your interested in when you select the transpose tool. Then you’ll use the unique tool an select both the name and value fields. Your output will be a list of your unique values.

Cheers,

Mark

akumarbvp

@MarqueeCrew

Thanks for prompt response, maybe since I am new to this tool so could not follow your suggestion.

I have the following data

Field1	Field2	Field3	Field4	Field5	Field6	Field7	Field8	Field9
a	a	a	a	a	a	a	a	a
b	b	b	b	b	b	b	b	b
g	g	g	g	g	g	g	g	g
j	j	j	j	j	j	j	j	j
a	b	g	j	a	a	a	a	a
a	b	g	j	a	a	a	a	a
a	b	g	j	a	a	a	a	a

and what I intend to achieve is following . Spreadsheet I am using has 200k rows.

Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9
a a a a a a a a a
b b b b b b b b b
g g g g g g g g g
j j j j j j j j j

I tried your suggestion with following workflow

and I am getting following result , maybe I did not follow you.

Field1 a
Field1 b
Field1 g
Field1 j
Field2 a
Field2 b
Field2 g
Field2 j
Field3 a
Field3 b
Field3 g
Field3 j
Field4 a
Field4 b
Field4 g
Field4 j
Field5 a
Field5 b
Field5 g
Field5 j
Field6 a
Field6 b
Field6 g
Field6 j
Field7 a
Field7 b
Field7 g
Field7 j
Field8 a
Field8 b
Field8 g
Field8 j
Field9 a
Field9 b
Field9 g
Field9 j

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167