Compare and combine files

Hello everyone,

I have multiple files in yxdb format, and I would like to combine them into a single yxdb file without any duplicate records while also maintaining the history. Please see attached sample excel file for required outputs. Appreciate your suggestions.

Thanks

sample.xlsx

Data Investigation

Accepted answers

adamweaver39

Hey @Harinder -- I think this formula should do the trick if I understand it correctly.

SampleEx - 4.10.24.jpg

Sample Workflow 4_10_24.yxmd

All comments

adamweaver39

Hi @Harinder -- please see attached workflow and let me know if this fulfills your goal. SampleEx - 4.9.24.jpg

Sample Workflow 4_9_24.yxmd

Harinder

Thanks, I want to compare the records date wise if its a new record then assign the action as "new" and if ID +category combination already exist then append the row with Action type "update" for that combination (group by ID and category).

adamweaver39

Hi @Harinder, gotcha. See updated workflow attached and below. I found this fairly straightforward to accomplish with a multi-row formula, grouped by id + category. You could also include property as an additional grouping consideration. Hopefully that does the trick!

SampleEx - 4.9.24.jpg

Sample Workflow 4_9_24.yxmd

Harinder

Thank you!

Much appreciated.

Actually, I would like the output to include null/blank values as well. If either of the properties is updated, then the action should be "update". If it is a new record, then the action is "insert", otherwise, the action is "same".