// Begin Code
java.util.Map<String, java.util.Map<String, java.util.List<String>>> idYearlyValues = new java.util.HashMap<>();
java.util.Map<String, java.util.Map<String, java.util.List<String>>> assessmentHistoryMap = new java.util.HashMap<>();
java.util.Set<String> uniqueIDs = new java.util.HashSet<>();
// Main Code
String assessmentId = out2.ASSESSMENT_ID; // Unique ID
String date = out2.Month; // Month as a string
String value = out2.CA_AMT; // The value to be stored
String year = out2.Year; // Year as a string
String assessmentHistoryId = out2.ASSESSMENT_HISTORY_ID; // Get the ASSESSMENT_HISTORY_ID
// Add the ID to the set of unique IDs
uniqueIDs.add(assessmentId);
// Initialize the map for the ID if it doesn't exist
idYearlyValues.putIfAbsent(assessmentId, new java.util.HashMap<>());
assessmentHistoryMap.putIfAbsent(assessmentId, new java.util.HashMap<>()); // Initialize history map for the ID
// Initialize the list for the year if it doesn't exist
idYearlyValues.get(assessmentId).putIfAbsent(year, new java.util.ArrayList<>(java.util.Collections.nCopies(12, "")));
assessmentHistoryMap.get(assessmentId).putIfAbsent(year, new java.util.ArrayList<>(java.util.Collections.nCopies(12, ""))); // Initialize history for the year
// Get the month from the Date
int month = Integer.parseInt(date) - 1; // Convert month to 0-11 index
// Get the list of monthly values for this ID and year
java.util.List<String> monthlyValues = idYearlyValues.get(assessmentId).get(year);
java.util.List<String> historyValues = assessmentHistoryMap.get(assessmentId).get(year); // Get history values
// Set the current month value
monthlyValues.set(month, value);
// Store ASSESSMENT_HISTORY_ID for the current month
if (assessmentHistoryId == null || assessmentHistoryId.isEmpty()) {
// If the current month history ID is empty, use the previous month's ID
if (month > 0) { // Ensure there is a previous month
String previousId = historyValues.get(month - 1);
if (previousId != null && !previousId.isEmpty()) {
// Append the current month number (1-based index)
assessmentHistoryId = previousId + "-" + (month + 1);
} else {
// If the previous month ID is also empty, set it to a default value
assessmentHistoryId = "DefaultID-" + (month + 1); // Adjust as needed
}
} else {
// For the first month, if there's no previous month, set a default ID
assessmentHistoryId = "DefaultID-1"; // Or handle this case as needed
}
}
historyValues.set(month, assessmentHistoryId); // Store the ASSESSMENT_HISTORY_ID for the current month
// Filling in null months with last available month's value for history IDs
String lastHistoryId = null;
for (int i = 0; i < historyValues.size(); i++) {
if (!historyValues.get(i).isEmpty()) {
lastHistoryId = historyValues.get(i); // Update last known history ID
} else if (lastHistoryId != null) {
// Fill with last known history ID plus current month ID
historyValues.set(i, lastHistoryId + "-" + (i + 1)); // i + 1 to get the 1-based month index
}
}
// Filling in null months with last available month's value for values
String lastValue = null;
for (int i = 0; i < monthlyValues.size(); i++) {
if (!monthlyValues.get(i).isEmpty()) {
lastValue = monthlyValues.get(i); // Update last known value
} else if (lastValue != null) {
monthlyValues.set(i, lastValue); // Fill with last known value
}
}
// End Code
System.out.println("ID\tHistory ID\tYear\tMonth\tValue"); // Table Header
System.out.println("-------------------------------------------------"); // Separator
for (java.util.Map.Entry<String, java.util.Map<String, java.util.List<String>>> entry : idYearlyValues.entrySet()) {
String id = entry.getKey();
java.util.Map<String, List<String>> yearValues = entry.getValue();
for (java.util.Map.Entry<String, java.util.List<String>> yearEntry : yearValues.entrySet()) {
String yearOutput = yearEntry.getKey();
java.util.List<String> values = yearEntry.getValue();
java.util.List<String> historyValues = assessmentHistoryMap.get(id).get(yearOutput); // Get corresponding history IDs
for (int month = 0; month < values.size(); month++) {
// Get the month value and history ID for the current month
String monthValue = values.get(month);
String monthHistoryId = historyValues.get(month);
// Print the ID, History ID, Year, Month, and Value in the specified order
System.out.printf("%s\t%s\t%s\t%d\t%s%n", id, monthHistoryId, yearOutput, month + 1, monthValue);
}
}
}
The provided code is designed to process and transform data within a Java application, specifically to aggregate assessment values and their corresponding history IDs on a monthly basis. However, when executing this code in the TJavaFlex component, the expected output—containing all the transformed data ready for insertion into a database—is not being achieved. Instead, it is only displaying the initial values prior to any transformations.
