How to Format Output as 'Key-Value Pairs' so Adobe Analytics Manager Can Ingest Data

[mlucero]

I need to output my data in 'key-value pairs' format so Adobe Analytics Manager can ingest the data.

Kev-Value Pairs requirements

1.  First field in every record is a unique id

2. All additional fields in every record must contain the header name, followed by an equals sign, followed by a value, i.e. "Account Type"="HAC"

Can anybody help me?  I have no idea how to do this in Alteryx.

I've attached a sample of the formatting required.

Thank you in advance

[AlexEntz · Accepted solution]

Hello mlucero,

this was an interesting use case. I think I managed to solve your problem. Here is my endresult:

I will attach the example workflow as well. Hope this helps :)!

Greetings Alex

[csmith11 · Accepted solution]

@AlexEntz 's Solution was awesome!

@mlucero I built off of @AlexEntz solution to get you to a text output file that should be ready for output. I all added the other fields that were missing. Let us know how this works for you!

Please consider liking our posts and marking as solution to help other community members identify solutions easier.

[mlucero]

Thank you so much! You made this look so easy now that I see it.