topic Re: collumns with the same name in QlikView

collumns with the same name

samuel_brierley — Thu, 17 Oct 2013 11:30:07 GMT

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

Re: collumns with the same name

rajni_batra — Thu, 17 Oct 2013 11:35:17 GMT

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

Re: collumns with the same name

christian77 — Thu, 17 Oct 2013 11:36:26 GMT

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.

Re: collumns with the same name

salto — Thu, 17 Oct 2013 11:42:34 GMT

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!

Re: collumns with the same name

christian77 — Thu, 17 Oct 2013 11:57:34 GMT

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.