Create duplicate rows - with interchanged column values from Original rows

[vibhapratha]

Hi,

The data available for loading is shown in 'Loaded Data'.
I would like to convert it into 'Required'.

Mainly I need to

                   1. Duplicate the original row.

                   2. Flip B as S or S as B

                   3. Add values (interchange values) from other columns in original row--> to the duplicate row.

Currently I am able to achieve this via macros. But since I have many such data, it is taking a lot of time.
Can anyone suggest me how I can handle this in QlikView itself ?

It will save enormous time for me.

Thanks.

[Arthur_Fong]

Hi,

U can try concatenating the tables:

     1. Load the original table. (Ex: Table A :column A1, A2, A3, A4, A5,A6,A7)

     2.  Then do

           concatenate(A)

           load "S" as A1,

                                   A2,

                                   A3, 

                                   A4,

                                   date(A4,'DDMMYYYY') as A5,

                                  A6,

                                  A6 as A7

            resident A;

Thanks and regards,

Arthur Fong

[Arthur_Fong]

Sample result as shown below:

Refer attached qvw below for reference.

Thanks and regards,

Arthur Fong

[vibhapratha]

Thank you very much for your solution. It was very useful and I was able to apply it. It  saves a lot of time.

I need to perform the concatenation on if the 'Product' field value is 'Swap'.
Please guide me.

[Arthur_Fong · Accepted solution]

There you go:

Refer updated qvw below for reference.

Thanks and regards,

Arthur Fong 

[vibhapratha]

Thank you. This method works perfectly !! 👍