Fill in a table used as a template with data from a dynamic table

[rtlane]

Hi Everyone,

I need some help :)

I have a table that I'm using as a template. The data in column 1 will never change and will always have the same number of rows and information in them but will have additional columns added based on data in table 2:

Table 1 (template)

Frequency

10

20

30

40

I then have a table that is created within the workflow that will change. This table will always have 3 columns but the number of rows can change:
Table 2

Id	Start Frequency	End Frequency
1234	9	21
789	8	31

I want the above table to be used to fill in the 1st table (my template) like below. If the frequency in my table 1 is within the range of the start and end frequency of table 2, make a column with the id in it.:

Frequency	id 1	id 2
10	1234	789
20	1234	789
30		789
40

Any help would be appreciated.

[LordNeilLord · Accepted solution]

hey @rtlane

How about something like this?

[rtlane]

Wow! It never ceases to amaze me how helpful and how quickly everyone on these forums respond. Thank you so much for your help!

[LordNeilLord]

You're very welcome!

The community here is awesome