Sorting Data | Picking the First Row of the Data

dunkindonut7777

can you recommend me on how to cleanse it in alteryx, what tool or process will i be using with this data:

Data:

GL Account Code	Business Unit	GL Account Name	Account Type	Account Class	Account Sub Type	Account Sub Class
19510000	IN	Misc Deposits	Assets	Other Current Assets	Asset	Miscellaneous Deposit
19510000	AP	Misc Deposit	Assets	Other Current Assets	Asset	Deposits to Suppliers
19510000	AN	Misc Deposit	Assets	Other Current Assets	Asset	Deposits to Suppliers

basically, it has the same account code but with different business unit, they have different GL Account Names. And I want to apply consistent GL Account Names by using the first GL account name in the row. N

GL Account Code	Business Unit	GL Account Name	Account Type	Account Class	Account Sub Type	Account Sub Class
19510000	IN	Misc Deposits	Assets	Other Current Assets	Asset	Miscellaneous Deposit
19510000	AP	Misc Deposits	Assets	Other Current Assets	Asset	Deposits to Suppliers
19510000	AN	Misc Deposits	Assets	Other Current Assets	Asset	Deposits to Suppliers

 

Note that it's only a sample entries, i want it to apply to the other codes and other data as well

Qiu

@dunkindonut7777 
We can use Sample tool to take out the first row for each "GL Account Code" then join back to the main data stream and use the "GL Account Code" from the first row of each "GL Account Code".

1218-dunkindonut7777.yxmd