topic Re: Table transform problem in QlikView

Table transform problem

peschu123 — Thu, 21 Nov 2013 11:10:51 GMT

Hi,

I have a table with the following columns:

Date

FAUF1

FAUF1_Schritt

FAUF1_ZeitPT

FAUF1_SOLL

FAUF1_R_Start

FAUF1_R_Stop

FAUF2

FAUF2_Schritt

FAUF2_ZeitPT

FAUF2_SOLL

FAUF2_R_Start

FAUF2_R_Stop

It is just a part of the table, it goes until "FAUF12_..." in same way.

I need it in a form like:

Date

FAUF

Schritt

ZeitPT

SOLL

R_Start

R_Stop

Or in words, I need to change the table, that I get it in Rows instead of columns. I tried a bit around with Cross Table but it didn't worked. I only got it working when I just use 4 fields FS, Date, FAUF1, FAUF2

Perhaps somebody can help me with this.

Thank you in advance and Regards,

Peter

Re: Table transform problem

Anonymous — Thu, 21 Nov 2013 12:17:30 GMT

Peschu

I asked a very similar question recently and I found it could solved either by using Crosstable or a loop.

Please see Convert Columns to Rows in load script

Best Regards, Bill

Re: Table transform problem

peschu123 — Thu, 21 Nov 2013 13:27:52 GMT

Hi Bill,

thank you for the link to the thread. Didn't found it via search.

It seems to be very helpful. I will take a deeper look the next days.

Peter