Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
My data looks like this:
Records | values |
records_0_Name | Jimmy |
records_0_Number | 1 |
records_0_Status | Student |
records_1_Names | Marie |
records_1_Number | 2 |
records_1_Status | Worker |
And i want it looks like this:
Name | Number | Status |
Jimmy | 1 | Student |
Marie | 2 | Worker |
Any ideas?
Hi,
What you aim to achieve here is a Pivot. This operation can be done in a dedicated Pivot, or Prepare recipes. Given we need first to clean the labels records, the latter recipe is the most straightforward option.
The following steps:
will provide the desired output: