i don't need all possible combination in the math sense, for my purposes 1234 and 4321 is the same thing, i'd only want to see a combination of 1,2,3,4 once, no matter which order
here's what i'm trying to do. (also, this is not a database, it's an automation tool for a task (to avoid suggestions to normalize my data)))))))))))
this tool matches one table to another using a number of fields. there're 10 fields all together but from a project to project only some fields are present. so today i'm only matching on 7 fields, tomorrow on 10, some other day on 5.
the matching goes like this. if there're 7 fields available - then first i try all 7, then all combinations of 6, all combinations of 5, all combinations of 4, all combinations of 3 and a few combinations of 2 (i will hand pick them so i don't care about them)
so for example, below are sample fields
101. Name
102. Address
103. CityState (to me they're 1)
104. ZIP
105. SSN
106. DOB
107. TIN
first i match on all - no problem, then on 6. how do i get all combinations of 6, like this
1. Name, Address, CityState, ZIP, SSN, DOB
2. Name, Address, CityState, ZIP, SSN, TIN
3. Name, Address, CityState, TIN, SSN, DOB
4. Name, Address, TIN, ZIP, SSN, DOB
and so on
i have numbers assigned to them, that's what the 101, 102, 103, etc, thought it'd make it easier
thank you!!
here's what i'm trying to do. (also, this is not a database, it's an automation tool for a task (to avoid suggestions to normalize my data)))))))))))
this tool matches one table to another using a number of fields. there're 10 fields all together but from a project to project only some fields are present. so today i'm only matching on 7 fields, tomorrow on 10, some other day on 5.
the matching goes like this. if there're 7 fields available - then first i try all 7, then all combinations of 6, all combinations of 5, all combinations of 4, all combinations of 3 and a few combinations of 2 (i will hand pick them so i don't care about them)
so for example, below are sample fields
101. Name
102. Address
103. CityState (to me they're 1)
104. ZIP
105. SSN
106. DOB
107. TIN
first i match on all - no problem, then on 6. how do i get all combinations of 6, like this
1. Name, Address, CityState, ZIP, SSN, DOB
2. Name, Address, CityState, ZIP, SSN, TIN
3. Name, Address, CityState, TIN, SSN, DOB
4. Name, Address, TIN, ZIP, SSN, DOB
and so on
i have numbers assigned to them, that's what the 101, 102, 103, etc, thought it'd make it easier
thank you!!