NWE
02-28-2019, 02:00 PM
Hi,
I have a table of roughly 8200 rows with 17 columns. 7 of those columns concatenated will give me a template value, with each column having between 2 and 20 different categories. Is there a way to count up the unique combinations and assign a template value? For example:
Co A Co B Co C Co D Co E F G = Column H
Fluorescent 0 Rural Interstate lin-under 2 na no = Template 1
Fluorescent 0 Urban Interstate lin-under 1 na no = Template 2
There are slight differences but every slight difference will require it's own template. Anyone have any experience with this? Thanks!
I have a table of roughly 8200 rows with 17 columns. 7 of those columns concatenated will give me a template value, with each column having between 2 and 20 different categories. Is there a way to count up the unique combinations and assign a template value? For example:
Co A Co B Co C Co D Co E F G = Column H
Fluorescent 0 Rural Interstate lin-under 2 na no = Template 1
Fluorescent 0 Urban Interstate lin-under 1 na no = Template 2
There are slight differences but every slight difference will require it's own template. Anyone have any experience with this? Thanks!