Creating a new column
have you tried using a pivot table and pivoting on your payor type field if you’re just wanting to display it in a table?
If you’re wanting to do it in your data set you can utilize a pivot tile in magic ETL**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
You could use a pivot table and put invoice payor type as a column and that would create a column for each.
You could also use Magic ETL to pivot the data using the Uncollapse Columns tile. See this KB article:
You could also create multiple beast mode, 3 for each payor type to do it.
Using the pivot table card would be the easiest.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Thanks Grant and Mark, it worked. Appreciate your help and quick response.0
@Liliana i strongly recommend against using Magic to uncollapse the data. if a new payer shows up your dataaflow will exclude them, b/c you haven't enumerated them.
Pivot Table is a safe solution but becomes unwieldy as you get more and more payers. What's the question you're trying to answer?Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Thanks, Jae I need to track payment by insurance and patients. I created the ETL , unpivot the data then created a table in SQL to bring some information over that I was not able to get in ETL. It worked with the unpivot as Grant and Mark recommended. However, now I am trying to create a total paid column (patient paid plus insurance paid) and it is giving me a cumulative amount. Not the correct balance per row.
This is how my columns look now.
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 79 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive