Rows to columns

zalakinc

Hello, Here is my scenario:

I have filtered out my text file so that only 3 types of rows from raw file are filtering out. Lets call them: 

GC, MC and total. In my flat file, there are many rows with these 3 starting points. Now I need to convert them into columns called: GC, MC & Total. Currently they are rows in a field I created called Field 1. Can you please advise on how to go about doing that?

Thanks

DataNath

Hey @zalakinc, you can use the Cross-Tab to go from Rows > Columns. You'll need to choose an aggregation when doing this. If you want to avoid doing so then you'll need to assign a unique ID to each of your sets of rows that you can then group on:

Before - row format:

After - Columns created:

To avoid aggregations if you want to keep groups of records split, you can add ID's with an approach like this (in the attached workflow):

Before:

After - split out by ID:

GC MC Total rows to columns.yxmd