ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
General Discussions
Discuss any topics that are not product-specific here.
Hi, I am getting the EIA data using an API but I am not understanding how to transpose the following output of the data.
| Jason_Value_String | 31 |
| Dollars per Gallon | units |
| W | f |
| $/gal | unitsshort |
| Missouri Propane Residential Price | description |
| 20220214 | end |
| 2022-02-16T13:20:22-0500 | updated |
| 20220214 | data |
| 2.508 | data |
| 20220207 | data |
| 2.507 | data |
| 20220131 | data |
| 2.434 | data |
| 20220124 | data |
| 2.408 | data |
I want the data in this format.
| units | f | unitsshort | description | end | updated | data | data |
| Dollars per Gallon | W | $/gal | Missouri Propane Residential Price | 20220214 | 2022-02-16T13:20:22-0500 | 20220214 | 2.508 |
| Dollars per Gallon | W | $/gal | Missouri Propane Residential Price | 20220215 | 2022-02-16T13:20:22-0501 | 20220207 | 2.507 |
| Dollars per Gallon | W | $/gal | Missouri Propane Residential Price | 20220216 | 2022-02-16T13:20:22-0502 | 20220131 | 2.434 |
| Dollars per Gallon | W | $/gal | Missouri Propane Residential Price | 20220217 | 2022-02-16T13:20:22-0503 | 20220124 | 2.408 |
I am not sure how to separate the below-highlighted rows into two different columns as there is a date 20220214 and the value 2.508 in the same columns.
Any suggestions/help would be appreciated.
