Transform a table

lsjogren — Tue, 28 Mar 2017 13:10:18 GMT

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

Re: Transform a table

aarkay29 — Tue, 28 Mar 2017 13:24:38 GMT

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;