topic How to load rows of data as separate columns? in QlikView

How to load rows of data as separate columns?

mwscott1 — Fri, 27 Jun 2014 14:22:59 GMT

I am working with a .CSV file with one column of user information. Each user has 3 rows of information. I need to load those rows as separate columns.

MailboxOwnerId : ID1

Name : JohnDoe@email.com

ForwardTo : JD@gmail.com

MailboxOwnerId : ID2

Name : JaneSmith@email.com

ForwardTo : JS@outlook.com

MailboxOwnerId :	Name :	ForwardTo :
ID1	JohnDoe@email.com	JD@gmail.com
ID2	JaneSmith@email.com	JS@outlook.com

Is this possible?

Re: How to load rows of data as separate columns?

Fri, 27 Jun 2014 14:27:57 GMT

Hi Melvin,

In what format is this data?

You can use the Enable Transformation Step to do this. When you select import Table Data and click next you get this option. You can then decide how to import the data.

Regards,

Marius

Re: How to load rows of data as separate columns?

jerem1234 — Fri, 27 Jun 2014 14:35:15 GMT

As Marius Koekemoer mentions, you can transform the data you load in. You will want to use the Transpose function in the filters of the specifications like:

Test:

LOAD @1 as Field1,

@2 as Field2,

@3 as Field3

FROM

Test1.csv

(txt, codepage is 1252, no labels, delimiter is ',', msq, filters(

Transpose()

));

If not, maybe you can use the Generic Load which is described here: http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Hope this helps!