Hello Everyone,
In the attached Sample workflow, I have a sample data set that consist of a Column that contains a Client Id, a column that consist of Parameter Names, and a column that consist of Parameter values. These Parameter Names are the Header for each Parameter value. These Parameter Names could be different for each client and the quantity number of parameters names could be different from client to client. I need a way to dynamically turn whatever quantity and values that are received into 2 or 3 columns that eventually looks like the output in the sample but in multiple columns.
Any suggestions? It is probably super easy to do but nothing I have tried so far has worked.
Ultimately I need the data to look like this (I used a photo editor to make this with the fields)
Solved! Go to Solution.
Thanks so much for your response!
More so where the data is like this
Instead of
Also the way that my output is designed, I can omit the client ID entirely, Forgot mention that. I added it initially as an anchor for the transform tools but it didn't pan out the way I was doing it.
I feel like I'm getting closer but trying to figure out now how to turn the record 1.1 into the header and 1.2 into the value so that I can remove the record ID. Don't know if this is the best way! My first time using the Multi-Field Binning Tool but it did help me separate the data into 3 columns
That looks like it will do the trick! Thanks
Upon testing various input sources, I found that previously accept method didn't produce as reliable output as I needed. I figured I would share the method I went with after lots of testing in case someone else needs to do this. I appreciate binuacs and EkatLol so much for jumping in to assist me, you guys really took the time to save my bacon today on a SUNDAY when most folks are relaxing and for that I'm grateful. This won't be the last time that I need to do this and the workflow I'm working on as a whole is MASSIVE. What I decided to go with is way more steps than I was hoping for. I am open to any other suggestions if someone has an easier way to accomplish this <3 I love to learn new ways to go about doing things. Thanks so much for the insight, even if I went a different direction, the insight is valuable because It helps me to see it from another angle.
NOTE: This workflow also removes the section if there is no data output as an extra bonus :)
Hope others find use in this if no one else replies with a better way