Transform a table

[lsjogren]

Hi

I have imported a Table from a RavenDB(document DB) via Qlik Rest Connector.

I Think a have a Customer table that looks like my example below.

Age and Gender on different rows.  What is the best way to handle  the situation?

Regards Lars

Nr	Name	City	Age	Gender
1	Ola	Lerum	23
2	Ola	Lerum		Male
3	Peter	Avesta	25
4	Peter	Avesta		Male
5	Kristina	Bjuv	27
6	Kristina	Bjuv		Female

[aarkay29]

May be this:

Table:

load * inline [ 

Nr, Name, City, Age, Gender

1, Ola, Lerum, 23,

2, Ola, Lerum, ,Male,

3, Peter, Avesta, 25,

4, Peter, Avesta, ,Male

5, Kristina, Bjuv, 27,

6, Kristina, Bjuv, ,Female

];

FinalTable:

Load

       Name,

       City,

       Age

Resident

      Table

Where

       len(Age)>0;

Left Join (FinalTable)

Load

       Name,

       City,

       Gender

Resident

       Table

Where

       len(Gender)>0;

Drop Table

       Table;