Populate list based on values for multiple groups

[nickstalec]

Hello, 

I am needing to fill in an amount from one table into a list of dates in another list. I have several groups, each with a value that needs to be put next to each day of the year. Any suggestions on how I would accomplish this? 

Desired result:

[atcodedog05]

Hi @nickstalec 

You can use a Join tool.

[Emil_Kos]

Hi @nickstalec,

You can use join tool/find and replace tool to achieve this result.

[atcodedog05]

Hi @nickstalec 

Here is a workflow for the task.

Inputs:

Lookup table

Data

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[nickstalec]

Thanks for the response. My problem is that my initial date list starts off blank, as shown below. I think I'd need to use a macro to fill in the Group name first, and then bring in the amount, and then repeat for each group. I am just kind of lost on where to start with that. 

[atcodedog05]

@nickstalec 

Oh ok this is a job for append tool.

[atcodedog05 · Accepted solution]

Hi @nickstalec 

Here is a workflow for the task.

Inputs:

Data

Lookup table

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[nickstalec]

Perfect. Exactly what I needed. Thank you! 

[atcodedog05]

Happy to help 🙂 @nickstalec 

Cheers and Happy Analyzing 😀