Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ...;
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 ...;
Easy enough.. that will do it, thanks!