topic Re: Combine fields on load in QlikView

Combine fields on load

twills12 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 28 Feb 2018 20:27:08 GMT

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 — Wed, 28 Feb 2018 20:56:42 GMT

Easy enough.. that will do it, thanks!