Add values from Web Form row as Columns to a Dataset
Hi,
I want to use a web form dataset to allow a user to enter values for 4 variables. Basically, a single row with 4 columns for the variable values. I want to then add these values as additional columns to each row in another dataset. What is the easiest way to do this?
The use case is, I want to be able to use the variables in beast mode calculations on a card but give a business owner the ability to manage the variable values seperately.
For example, if my web form is:
Variable 1 | Variable 2 | Variable 3 | Variable 4 |
1 | 5 | 20 | 3 |
And my dataset is:
Date | Price |
2/25/19 | $5.00 |
2/19/19 | $6.00 |
1/19/19 | $7.00 |
I want to append the web form columns to my data set like so:
Date | Price | Variable 1 | Variable 2 | Variable 3 | Variable 4 |
2/25/19 | $5.00 | 1 | 5 | 20 | 3 |
2/19/19 | $6.00 | 1 | 5 | 20 | 3 |
1/19/19 | $7.00 | 1 | 5 | 20 | 3 |
Best Answer
-
In order to join two tables horizontally, there needs to be at least one column in common on both to achieve the join you are looking for, so you'd need to add that to each table. After that's, it's a simple join.
E.g. add a column to both tables with the value of "1", and then join on that new column. Can provide a more specific example if that will help you.
However, this will result in a lot of duplicate data, which depending on the size of your primary dataset can cause performance issues.
I realize that Domo does not allow for accepting user input, and this is a creative way to circumvent that limitation, but I recommend reviewing this strategy later down the road.
1
Answers
-
That was actually a surprisingly simple solution that worked perfectly. The dataset is around 250 rows so I'm not all that concerned with performance at that scale.
Thanks for the help.
0
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部