topic Group records in a single line in QlikView

Group records in a single line

salto — Wed, 11 Aug 2010 17:00:12 GMT

Hello,

I have Table A, with this appearance:

TransID - Line - DimID - DimValue

1 - 1 - A - 11A

1 - 1 - B - 11B

1 - 2 - A - 12A

1 - 2 - B - 12B

2 - 1 - A - 21A

2 - 1 - B - 21B

and I need to convert it to:

TransID - Line - A - B

1 - 1 - 11A - 11B

1 - 2 - 12A - 12B

2 - 1 - 21A - 21B

How can this be achieved in Qlikview?

Thanks in advance.

Group records in a single line

salto — Wed, 11 Aug 2010 18:31:07 GMT

Sorry,I did not know about "Generic Load" and the feature it has for flattening a table. I will try with this and keep an update here.

Thanks.

Group records in a single line

salto — Wed, 11 Aug 2010 20:09:17 GMT

Well, it is me again. Sorry 😉

I am trying this:

generic load TransID, Line, DimID, DimValue resident TableName;

But QV converts it to 2 different tables, by DimID instead of only one "flattered" table. My idea is to use TransID and Line as table keys.

Does anybody know why is QV separating the table in two? Is it because the name I am using for the field is DimID instead of, for example, Dimension?

Regards,

Josetxo

Group records in a single line

johnw — Wed, 11 Aug 2010 20:27:33 GMT

That's just how the generic load works. If you really want to get everything back in one table, you could probably left join them back together in a loop. I could swear I wrote an example, but I can't seem to find it. I also could have sworn Rob Wunderlich had an example in his cookbook, but again, I'm not finding it.