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
-
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 -
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
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive