AWB_Duplicates_Duties

AWB Duplication:Part 1-<ol><li>Excel Reader to import the data.</li><li>Row filter is used to merge duties and credits based on shipment number.</li><li>Concatenates all the imported data.</li><li>Filter the column which is required.</li><li>String manipulation is used to join order number and shipment number.</li><li>Aggregated the count based on shipment numbers.</li><li>Used inner join to join the 3 columns shipment number, base amount and counts.</li><li>Group By- shipment number and counts also aggregated the base amounts.</li><li>Math Formula to round off the amounts.</li><li>Java snippet- Java code use for different conditions based on counts of shipment numbers.</li><li>Row filters to segregates duplicates.</li><li>Used joiner to join the respective data we want for the duplicates.</li><li>For count=4, we use row filters and duplicates filters to filter out the duplicate shipment numbers.</li><li>Joiner to join all the data we required to move further.</li><li>We can export the duplicates file to excel before checking final part.</li></ol>Part 2-<ol><li>Import the detailed month data.</li><li>Used value lookup from the duplicates we found and the main detail data.</li><li>Group by with names.</li><li>Used 2 row filters to filter out shipment numbers with same and different names.</li><li>2 Joiner is used to join the whole data with the outputs(inner join technique implemented to join).</li><li>Again group by is performed to group with origin and destination to the outputs.</li><li>For duplicates again inner join is implemented to get the final output with other data.</li><li>For non-duplicates- row filter is used to segregates the different types of output mentioned in the comment section.</li><li>Last group by with the order number to get final duplicates.</li><li>To merge all the duplicates-concatenate is used.</li><li>Export to excel to get final duplicates in excel.</li></ol>

AWB Duplication:

Part 1-

Excel Reader to import the data.
Row filter is used to merge duties and credits based on shipment number.
Concatenates all the imported data.
Filter the column which is required.
String manipulation is used to join order number and shipment number.
Aggregated the count based on shipment numbers.
Used inner join to join the 3 columns shipment number, base amount and counts.
Group By- shipment number and counts also aggregated the base amounts.
Math Formula to round off the amounts.
Java snippet- Java code use for different conditions based on counts of shipment numbers.
Row filters to segregates duplicates.
Used joiner to join the respective data we want for the duplicates.
For count=4, we use row filters and duplicates filters to filter out the duplicate shipment numbers.
Joiner to join all the data we required to move further.
We can export the duplicates file to excel before checking final part.

Part 2-

Import the detailed month data.
Used value lookup from the duplicates we found and the main detail data.
Group by with names.
Used 2 row filters to filter out shipment numbers with same and different names.
2 Joiner is used to join the whole data with the outputs(inner join technique implemented to join).
Again group by is performed to group with origin and destination to the outputs.
For duplicates again inner join is implemented to get the final output with other data.
For non-duplicates- row filter is used to segregates the different types of output mentioned in the comment section.
Last group by with the order number to get final duplicates.
To merge all the duplicates-concatenate is used.
Export to excel to get final duplicates in excel.

AWB_​Duplicates_​Duties

Nodes

Extensions

Links

Download

AWB_Duplicates_Duties