Adding comments when joining a rolling file and a new daily file

[u202760]

I've been working on this workflow for a minute and needed some fresh eyes to take a look at my situation. I have an automated daily file that gets created each morning to show the past due orders, this workflow outputs an excel file into a folder that associates then add comments to and save, the second portion of the workflow pulls yesterdays file with the added comments, I am having trouble appending these files together so that the comments get transferred over as well as pulling the new orders that are past due, any idea how I might do this? There is a column that essentially acts as a serial number that can be used to tie together the past due orders with comments to those that got required form the new days output.

[mceleavey]

Hi @u202760 ,

can you provide some mock data and an example of what you want and we can help.

Thanks,

M.

[csmith11 · Accepted solution]

What I understand you are trying to accomplish is handling Historical Data Vs New Data.

Simply approach I like to use is join data together with a Join Tool. The L output Anchor will contain new data. And the J output contains the data that was already in the Historical Data set. (See Example Below and Attached)

[u202760]

Thats exactly what I was trying to do, thank you!