Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

rtlane
8 - Asteroid

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.

3 REPLIES 3
LordNeilLord
15 - Aurora

hey @rtlane

 

How about something like this?

 

Frequency.PNG

rtlane
8 - Asteroid

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
15 - Aurora

You're very welcome!

 

The community here is awesome

Labels