Table in QlikView

[fabio182]

Hello gays,

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

View Image. Thanks for your help

[#2]

Is that an excel file ?

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

[fabio182]

I don't know, that's my question

[#4]

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.

[JonnyPoole]

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);

[#6]

Good, is similar to the pivoting insert in sql

[MarcoWedel · Accepted solution]

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

.

[fabio182]

Thank you so much Marco !!!!!

[MarcoWedel]

You're welcome

Regards

Marco