Using java.util.List and java.util.HashSet In Tjavaflex Component

JosephMansour — Tue, 29 Oct 2024 14:30:07 GMT
// 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.
 
 
 
topic Using java.util.List and java.util.HashSet In Tjavaflex Component in Talend Studio

Using java.util.List and java.util.HashSet In Tjavaflex Component
