Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to pad data with existing data

Charlie_xiao
6 - Meteoroid

Hi,  I have two tables, table 1 and table 2. The table 2 missed some data (scale, force) for low speed values. But table 1 has the data for low speed values. So I want to pad the second table by using the data from table 1.  The padded table 2 should looks like table 3. Note that I am only using 'Scale' and 'Force' from table 1 to pad table 2, the index in table 3 should be the same as table 2. And that is why table 3 has all 'Index' equal to 4.

 

Table 1

clipboard_image_0.png

 

Table 2

clipboard_image_1.png

 

table 3

clipboard_image_2.png

 

Thanks

Charles

2 REPLIES 2
MichaelSu
Alteryx Alumni (Retired)

Hi @Charlie_xiao ,

 

Please see attached solution. This is how I thought to accomplish what you're looking to do, I am sure there are multiple ways. Let me know if you have any questions.

 

Thanks,

Mike

Charlie_xiao
6 - Meteoroid

Thank you so much!!!! It is a very good solution!

Charles

Labels
Top Solution Authors