Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
fabio182
Creator II
Creator II

Table in QlikView

Hello gays,

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

View Image. Thanks for your help

Obs.jpg

1 Solution

Accepted Solutions
MarcoWedel

Hi Fabio,

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

So one solution could be:

QlikCommunity_Thread_136580_Pic1.JPG.jpg

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


.

View solution in original post

8 Replies
Not applicable

Is that an excel file ?

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

fabio182
Creator II
Creator II

I don't know, that's my question

Not applicable

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

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

Capture.PNG.png

Not applicable

Good, is similar to the pivoting insert in sql

MarcoWedel

Hi Fabio,

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

So one solution could be:

QlikCommunity_Thread_136580_Pic1.JPG.jpg

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


.

View solution in original post

fabio182
Creator II
Creator II

Thank you so much Marco !!!!!

MarcoWedel

You're welcome

Regards

Marco