Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Meteor

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

IdStart FrequencyEnd Frequency
1234921
789831

 

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.:

Frequencyid 1 id 2
101234789
201234789
30 789
40  

 

Any help would be appreciated.

Highlighted
Alteryx Certified Partner

hey @rtlane

 

How about something like this?

 

Frequency.PNG

Highlighted
Meteor

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

Highlighted
Alteryx Certified Partner

You're very welcome!

 

The community here is awesome

Labels