Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

mlucero
5 - Atom

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

3 REPLIES 3
AlexEntz
8 - Asteroid

Hello mlucero,

 

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

 

AlexEntz_0-1635489149037.png

 

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

 

Greetings Alex

csmith11
11 - Bolide

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

 

csmith11_0-1635523197042.png

 

mlucero
5 - Atom

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

Labels