Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
peschu123
Partner
Partner

Table transform problem

Hi,

I have a table with the following columns:

FSDateFAUF1FAUF1_SchrittFAUF1_ZeitPTFAUF1_SOLLFAUF1_R_StartFAUF1_R_StopFAUF2FAUF2_SchrittFAUF2_ZeitPTFAUF2_SOLLFAUF2_R_StartFAUF2_R_Stop

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

I need it in a form like:

FSDateFAUFSchrittZeitPTSOLLR_StartR_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

2 Replies
bill_markham

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
Partner
Partner
Author


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