topic Table in QlikView in QlikView

Table in QlikView

fabio182 — Mon, 06 Oct 2014 15:00:43 GMT

Hello gays,

It's possible convert from Table 1 to Table 2?

View Image. Thanks for your help

Re: Table in QlikView

Mon, 06 Oct 2014 15:08:10 GMT

Is that an excel file ?

Can´t you change it with the wizard and then put the data into the table?

Re: Table in QlikView

fabio182 — Mon, 06 Oct 2014 15:12:22 GMT

I don't know, that's my question

Re: Table in QlikView

Mon, 06 Oct 2014 15:16:35 GMT

Im not sure but...

Ok, you have to transform that cross table to a normal table

Read this article

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

Let me know if that is useful for you, or if you dont understaund the article, but i think is very clear.

Cheers.

Re: Table in QlikView

JonnyPoole — Mon, 06 Oct 2014 15:20:41 GMT

You can do a 'generic load' which turns the 2nd field into a series of unique fields (1 for each unique value).

The generic load needs 3 parameters so i added an extra 1 (calculated).

generic LOAD ID,

cdscr_fam,

RecNo() as Number

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Table in QlikView

Mon, 06 Oct 2014 15:23:04 GMT

Good, is similar to the pivoting insert in sql

Re: Table in QlikView

MarcoWedel — Mon, 06 Oct 2014 15:45:20 GMT

Hi Fabio,

you are looking for the opposite of a crosstable load, a generic load.

So one solution could be:

Generic

LOAD ID,

'Producto'&AutoNumber(RecNo(),ID),

cdscr_fam

Inline [

ID, cdscr_fam

32020-sem14_2010, CRISOL GRANEL FS

32020-sem14_2010, Harini Nicolini

32020-sem14_2010, Primor Envasado

32020-sem14_2010, Sello de Oro Granel

32020-sem14_2011, CRISOL GRANEL FS 1

32020-sem14_2011, Harini Nicolini 1

32020-sem14_2011, Primor Envasado 1

32020-sem14_2011, Sello de Oro Granel 1

32020-sem14_2012, CRISOL GRANEL FS 2

32020-sem14_2012, Harini Nicolini 2

32020-sem14_2012, Primor Envasado 2

32020-sem14_2012, Sello de Oro Granel 2

];

hope this helps

regards

Marco

Re: Table in QlikView

fabio182 — Mon, 06 Oct 2014 16:08:01 GMT

Thank you so much Marco !!!!!

Re: Table in QlikView

MarcoWedel — Mon, 06 Oct 2014 16:09:14 GMT

You're welcome

Regards

Marco