collumns with the same name

[samuel_brierley]

hi first of all thanks for any help,

im trying to load collumns in the order shown below but qlikview wont let me because they have to be unique, I understand this but I really don't want to have to separate into different sheets or work books.

date                  name                date                       name

01/01/2013       sam                  02/01/2013            mark

I have tried naming the collumns differently and using the as function in the script and creating a table in the excel file but these haven't worked

its pretty important that I find a way to get qlikview to see this as

date                       name

01/01/2013            sam

02/01/2013            mark

thanks for the help

[rajni_batra]

If your data is coming from two diff data sources then you can concatenate them with same field name.

[christian77]

Hi:

Try reloading your columns by pairs.

LOAD

     date (1st col)          as Date,

     name(2nd col)          as Name

from........

concatenate

LOAD

     date (3rd col)          as Date,

     name(4th col)          as Name

from........

you'll get a table with 2 columns and all the data on it.

[salto]

Just a small thing: the concatenate sentence is not really neccesary in the previous post since Qlik will concatenate tables with the same column names. Sorry... and best regards!

[christian77]

Exactly. That is the base of QlikView. Imagine you have 2 tables with 10 same field names. If you say noconcatenate you'll get a Syn table in the middle with no tables aside.

Sometimes we load from resident, with the same fields, then drop the original table and realize that nothing is left. The new loaded table has concat to the original and then we've dropped all.

That's QlikView.