topic Re: Need to merge row for few columns only for same values in qlik sense cloud native object straight table in App Development

Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Shiva_65481241 — Mon, 28 Oct 2024 09:55:21 GMT

I wanted to merge 2 rows in a straight table only for few columns for particular periodic months only after that there should be the 2 different rows. Please seethe below screen shot for the o/p i am looking for.

@sunny_talwar

Re: Need to merge row for few columns only for same values in qlik sense cloud native object straight table

Qrishna — Mon, 28 Oct 2024 07:38:55 GMT

In a straight table this is not possible. try using pivot table.

Re: Need to merge row for few columns only for same values in qlik sense cloud native object straight table

Shiva_65481241 — Mon, 28 Oct 2024 09:54:12 GMT

Thank you @Qrishna for your response, but the requirement is straight table only. May I know how we can make it in pivot table also.

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

seanbruton — Mon, 28 Oct 2024 10:37:57 GMT

Hi,

In your data model normalize the two rows column with an alias, then replace the dimension with the new normalized fields. This will work. Please note that any dimension field shown on straight table will create a new line. You will also get null values in the table untick include null values

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Kushal_Chawda — Mon, 28 Oct 2024 10:43:31 GMT

@Shiva_65481241 How your merged values in the dimension should look like?

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Shiva_65481241 — Mon, 28 Oct 2024 11:57:46 GMT

Hello @seanbruton Thanks for the response but the dimensions are dynamic for the month and year period, how we can make it in backend with the normalization technique. could you please advise for the same, Thank you!

FYI- till sept-2024 only they want 1 merged row because till sep-2024 that station was single only but from new year it has been separated so afterwards they will, have 2 rows with 2 values. and month period column is dynamically calculated, but till sept 2024 we can hardcode the values for that 2 stations.

See the snapshot below how straight table will look like.

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

seanbruton — Mon, 28 Oct 2024 12:01:12 GMT

Hi,

Here is an example:

Col_A ; Col_B ; Col_C

CCN News; 2024; 03

Use:

Col_A &'|'& Col_B &'|'& Col_C as Key_1

The data will look like; CCN News|2024|03

To show or extract the data you can use subfields or replace functions.

I hope this helps.

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Shiva_65481241 — Mon, 28 Oct 2024 13:08:28 GMT

Thanks @seanbruton but This won't help, I gave you above the scenario and yours Solution is not working there for me.

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Shiva_65481241 — Mon, 28 Oct 2024 13:13:03 GMT

Hello @Kushal_Chawda , this snapshot i have taken from excel which user shared with us as a requirement that is not a Qlik straight table. I hope this is what u have asked me?

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Kushal_Chawda — Mon, 28 Oct 2024 14:41:52 GMT

@Shiva_65481241 But I don't understand which cell needs to be merged here

Re: Need to merge 2 rows for few columns only for same values in qlik sense cloud native object straight table

Shiva_65481241 — Tue, 29 Oct 2024 05:17:04 GMT

Hello @Kushal_Chawda could you see the snapshot which i have shared in above reply section you will understand what i am looking for. Thank you!