topic Create duplicate rows - with interchanged column values from Original rows in QlikView

Create duplicate rows - with interchanged column values from Original rows

vibhapratha — Sat, 16 Nov 2024 02:42:24 GMT

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.

Re: Create duplicate rows - with interchanged column values from Original rows

Arthur_Fong — Tue, 20 Aug 2019 00:22:25 GMT

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

Re: Create duplicate rows - with interchanged column values from Original rows

Arthur_Fong — Tue, 20 Aug 2019 01:01:08 GMT

Sample result as shown below:

Refer attached qvw below for reference.

Thanks and regards,

Arthur Fong

Re: Create duplicate rows - with interchanged column values from Original rows

vibhapratha — Tue, 20 Aug 2019 08:38:17 GMT

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.

Re: Create duplicate rows - with interchanged column values from Original rows

Arthur_Fong — Wed, 21 Aug 2019 00:36:18 GMT

There you go:

Refer updated qvw below for reference.

Thanks and regards,

Arthur Fong

Re: Create duplicate rows - with interchanged column values from Original rows

vibhapratha — Wed, 21 Aug 2019 07:42:01 GMT

Thank you. This method works perfectly !! 👍