Hello Alteryx Expert,
How to convert data from below format
To
Good morning @html82!
I've extended @Aguisande's solution to dynamically look at your field names and create a denormalized view of the data. The first step is to find all of the "Named" fields and then to create records for each set. The assumption being that the set of field names is constant. If you add a DATE field or Subject field (or both), this solution will provide an answer.
Cheers,
Mark
Hi @html82
As almost all operations, there are several ways to accomplish them in Alteryx. What I'd do is to standarize the Records first.
To do this, assign a RecordID, and then use a MultiRow formula tool to assign to the second record, the same RecordID as the previous record (Since I guessed the order matters in the pairing)
The MultiRow Config should be like this (Update values for RecordID, and the Expression should be:
IF [RecordID]!=1 THEN [RecordID]-[Row-1:RecordID] ELSE 1ENDIF
(If not the first RecordID, assign the previous RecordID's Value), else (Is the First Record, just assign 1)
Then, CrossTab, grouping by RecordID (Because of the results of the previous step, they should be the same for every pair of records):
You can see the results here:
Hope this helps.
Hi, this would work for this scenario, but I looking flexible solution, example below:
In this case, the solution would generate wrong output because there a new data 'from' which would break logic.
Hi , process seem to be working for non complex string , i am fetching an API , how can i transfer the Jason name data into column , file attached
what are you trying to achive its not quite clear what you want to convert. You can post your desired that way it is more explicit
Hi all,I have an additional question to what is posted here.Regarding the following scenario, where two or more websites can belong to "Larry". I just changed the original table slightly and added one row which belongs to Larry as well. So my idea is that all rows above the name belong to the name. It can be either one, two or as many you like. Any idea how I could archieve this? I am kinda struggeling to automize it as I don´t know for the table, how many website would belong to one name, it is changing consistently.
If I use the provided solution I would receive Tim as owner of google and so on, which would be wrong.
I guess I need to change it in the multi row function but did not find a solution yet.
Hopefully somebody could help me out here.
Best Joma
The result should be:
