Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

How to merge data from Summarize output

Sanjana_HS
8 - Asteroid

Hi I have date from Summarize tool which is maximum end date now this result i want to merge with original data without duplicating values how to do that?

Summarize tool output :

Sanjana_HS_0-1681925739923.png

Original data:

Sanjana_HS_1-1681925773751.png

So when i use joint tool i want max date picked from summarize tool and the date from original data to vanish. however when i try this my join tool is giving me 1,667 records which should be 1,626




7 REPLIES 7
martinding
13 - Pulsar

Hi @Sanjana_HS 

 

I see in your screenshot, that you have duplicates in the Max dates fields, and that's why when you join with the original, it will create duplicates.

martinding_0-1681967926416.png

 

There are at least 3 approaches you can take:

 

martinding_1-1681968172300.png

 

 

Sanjana_HS
8 - Asteroid

No the date relates to different persons

martinding
13 - Pulsar

@Sanjana_HS 

 

Could you please provide a sample data set?

 

It is difficult to determine what happened based on the two screenshots alone.

Sanjana_HS
8 - Asteroid

@martinding Here you go. If you see in joint out put ID 12172 is coming twice. One entry with Maximum date one with normal date.
What i am trying to achieve is for the ID 12172 i want entry of the latest date which is 2023-01-17 to 2024-01-30 to flow from Joint output tool. If there is any other way also please let me know

Appreciate your help

ShankerV
17 - Castor

Hi @Sanjana_HS 

 

Please add the filter tool to get the desired result. It cannot be controlled in the Join tool.

 

ShankerV_0-1681981861302.png

 

[Start Date] >= [Max_Start Date] AND
[Start Date] <= [Max_End Date]

 

 

ShankerV_1-1681981875254.png

 

 

Many thanks

Shanker V

martinding
13 - Pulsar

Hi @Sanjana_HS,

 

Is this what you needed?

Only 1 entry for ID 12172, which is the latest date from 2023-01-17 to 2024-01-30.

martinding_0-1681981900004.png

 

Sanjana_HS
8 - Asteroid

@martinding @ShankerV  Thank you it worked :)

Labels