How to bring Row data into Columns?

TejasweeN

Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2.

Do I need to create Hierarchy list and Map?

anikdas

@TejasweeN You need some form of indicator to connect the two rows of data. Assuming that your linking field is routing order and envelope id, create a module by envelope id and routing order as dimensions and store the relevant information. You can do that using formulas or as part of your import process. Once you have that, lookup by envelopeid and previous routing number in the destination module dimensioned by Unique id. In a nutshell, follow the steps below:

• create dimension envelope id
• create dimension routing order
• Create module dimensioned by envelope id and routing order - Module A
• Identify the routing order to lookup in the module dimensioned by Unique ID
• Lookup from the module A using envelope id and routing order to lookup