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

Question

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

ftp_dpm_1234_1445374061.txt

AlexEntz · Accepted Answer

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 Answer

@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.