Combine fields on load

[twills12]

I have loaded data and now have a table with 8 columns and 1 row.

Asset1	Date2	CompletedBy3	Manager4	Asset5	Date6	CompletedBy7	Manager8
Server	5/25/2017	Dan	Kelly	Process	4/24/2017	Michael	Melissa

Within the load I would like to take this table and end up with 4 columns with 2 rows.

Asset	Date	CompletedBy	Manager
Server	5/25/2017	Dan	Kelly
Process	4/24/2017	Michael	Melissa

Seems simple but haven't been able to get it to work yet.

[sunny_talwar · Accepted solution]

Why don't you just load the data twice and do a concatenate

Table:

LOAD Asset1 as Asset,

     Date2 as Date,

     CompletedBy3 as CompletedBy,

     Manager4 as Manager

FROM ...;

Concatenate (Table)

LOAD Asset5 as Asset,

     Date6 as Date,

     CompletedBy7 as CompletedBy,

     Manager8 as Manager

FROM ...;

[twills12]

Easy enough.. that will do it, thanks!