Export same column headres

[anuradhaa]

Hi,

In my CSV i have same column headers,

say

ID,

USER,

USER

I need to export this to qlikview. How can i do this

[sunny_talwar]

May be something like this?

Table:

LOAD ID,

          USER

FROM Source.csv;

Concatenate (Table)

LOAD ID,

          USER1 as USER

FROM Source.csv;

[anuradhaa]

My CSV is like this,

ID	USER	USER
434	erete	yyhthtg
3453245	etet	fhh
35	rtrt

[sunny_talwar]

What is the output you are expecting while loading this into QlikView?

[Anonymous]

Hi,

You can try this:

Table:

LOAD ID,

          USER,

          USER as USER_1

FROM Source.csv;

[anuradhaa]

Load

ID,

User " - " User as USER

Or

Load

ID,

User as User 1

User as User 2

[sunny_talwar · Accepted solution]

I think by default QlikView will consider first USER as USER and second instance of USER as USER1. So Your second method is just default. To get the first option, may be this?

LOAD ID,

          USER & '-' & USER1 as USER

FROM ...

[varshavig12]

By default QlikView will consider it as USER 1

Directory;

LOAD ID,

     USER,

     USER1

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

n then you can use alias

Directory;

LOAD ID,

     USER as USER1,

     USER1 as USER2

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

this is for data from Excel.

[PradeepReddy]

try like this...

Test:

LOAD A as ID,

     B as User1,

     C as User2

FROM

Test.xlsx

(ooxml, explicit labels, header is 1 lines, table is Sheet1);

Note: I have taken  Data in Excel instead of CSV file