topic Re: Export same column headres in QlikView

Export same column headres

anuradhaa — Fri, 29 Jan 2016 09:44:19 GMT

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

Re: Export same column headres

sunny_talwar — Fri, 29 Jan 2016 09:46:45 GMT

May be something like this?

Table:

LOAD ID,

USER

FROM Source.csv;

Concatenate (Table)

LOAD ID,

USER1 as USER

FROM Source.csv;

Re: Export same column headres

anuradhaa — Fri, 29 Jan 2016 09:55:47 GMT

My CSV is like this,

ID	USER	USER
434	erete	yyhthtg
3453245	etet	fhh
35	rtrt

Re: Export same column headres

sunny_talwar — Fri, 29 Jan 2016 09:57:22 GMT

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

Re: Export same column headres

Anonymous — Fri, 29 Jan 2016 09:57:58 GMT

Hi,

You can try this:

Table:

LOAD ID,

USER,

USER as USER_1

FROM Source.csv;

Re: Export same column headres

anuradhaa — Fri, 29 Jan 2016 10:09:00 GMT

Load

ID,

User " - " User as USER

Load

ID,

User as User 1

User as User 2

Re: Export same column headres

sunny_talwar — Fri, 29 Jan 2016 10:11:47 GMT

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 ...

Re: Export same column headres

varshavig12 — Fri, 29 Jan 2016 10:17:07 GMT

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.

Re: Export same column headres

PradeepReddy — Fri, 29 Jan 2016 10:22:43 GMT

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