Table transform problem

[peschu123]

Hi,

I have a table with the following columns:

FS

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:

FS

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

[Anonymous]

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

[peschu123]

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