Hello -
I'm working on a database that downloads csv files, formats them, and appends them to certain tables. The current version I inherited uses a ton of iff statements to classify the data instead of using relationships. (Base) is based on a csv file, just raw data. It lists certain characteristics about a bond. I have another table, SecType, that classifies the bond based on (Base)'s characteristics. For instance, if (Base) has Fixed Agency, AFS, null, as Category, Intent, RepriceFreq, respectively, the table SecType will classify it as FixedAgencyAFS as it's PLShortName. Please see the attached screenshots for more clarification. I need to relate (Base) and SecType in a way that will populate PLShortName based on (Base)'s characteristics in a certain query I'm working on. Any help is much appreciated!
I'm working on a database that downloads csv files, formats them, and appends them to certain tables. The current version I inherited uses a ton of iff statements to classify the data instead of using relationships. (Base) is based on a csv file, just raw data. It lists certain characteristics about a bond. I have another table, SecType, that classifies the bond based on (Base)'s characteristics. For instance, if (Base) has Fixed Agency, AFS, null, as Category, Intent, RepriceFreq, respectively, the table SecType will classify it as FixedAgencyAFS as it's PLShortName. Please see the attached screenshots for more clarification. I need to relate (Base) and SecType in a way that will populate PLShortName based on (Base)'s characteristics in a certain query I'm working on. Any help is much appreciated!
