Duplicate Data Issue

[swapsingh2712]

Hello Team,

I've a two tables,

table 1 contains the cust information like cust_id and Cust_card Number and table 2 contains the cumulative information like total_cust etc. Both of them have only MTH column same. when I'm joining these 2 tables I'm receiving the duplicate values in the final table. Is there any way in alteryx to remove these duplicate cumulative values from the final table.?

Please find the table values attached 

Thanks

[alexnajm]

What do you want the final product to look like?

[swapsingh2712]

The final output shouldn't have the duplicate values, I've attached how It should look. 

[swapsingh2712]

similar to this I've multiple  cumulative table that needs to be merged and I'm thinking if there's a way in alteryx to remove these

[alexnajm]

You can then use the multi row formula tool to clear out the "duplicate" values for each column - you'll have to do it 4 times for each column. Or you can likely leverage this macro: Multi-Row -Field -Column Macro example - Alteryx Community

The other way would be to use a RecordID tool (grouped by Mth), filter the data to RecordID=1 only, do the Join on that record only, then Union that result with the other records. Let us know how it goes!

(If you want direct help, you'll have to provide the data in Excel)

[swapsingh2712]

actually I just provided the dummy data, my actual data set is pretty big (more then 1M rows) so I'm not sure how many times the values are being repeated , not sure If I can use the multi row formula. Regarding the other way to use the Record_ ID tool, Could you please provide an example on how to implement. I'll see If I can provide you the dummy data in excel from my end. Thank you so much for your response

[alexnajm]

You can use the multi row formula, that shouldn't be a concern. But I don't see data in Excel in this post - if you want direct help, please provide some sample data in Excel form. Doesn't have to be the full thing. Otherwise good luck!

[swapsingh2712]

Please find the excel attached. First tab shows the merged data and rest of the two tabs are the individual tables. If possible I want to fix the merged data as I cannot make changes to the individual table and the join conditions as it's running in the database. I need to just fix the final merged data. My actual data set have more then 20 rows and I'm not sure how many times the aggregated columns being repeated

Thanks

Swapnil 

[alexnajm]

Here you go - if you don't need it per month, remove the grouping from the RecordID tool!

[binu_acs]

@swapsingh2712 Another method using tile tool