changing column into row

[qlikapple]

Hi all , can anyone pleae help me, as it is very urgent

CRNO

OUTID

ONLINE

DEGRADED

MINUTES

CR2578038

1

N

Y

10

2

N

Y

20

3

Y

N

30

4

Y

N

40

Actually the requirement is ther is one filed called Outscopewhich is either online or degraded, I have to keep the flags Y or N

so in the backend I have creaated flags for both and cretaed 2 fileds like below

if(MATCH(SCOPE_NAME,'DEGRADED'),'Y','N') as DEGRADESCOPE,

if(MATCH(SCOPE_NAME,'ONLINE'),'Y','N') as ONLINESCOPE,

Now my requirement is there is one field called Minutes, similarly I have to diffrenetiate the sum of the ONLine minutes   and sum of the Degraded minutes

I need to bring like this

CRNO

ONLINE

DEGRADED

ONLINEMINUTES

Degrade MINUTES

CR2578038

N

Y

30

70

I want like above , how to do in back end, I need to get in the same row

[zhadrakas]

Here is a script that should fit your Needs:
Replace the first Inline Load with your current Load Statement.

TEST:
LOAD * INLINE [
CRNO, OUTID, ONLINE, DEGRADED, MINUTES
CR2578038, 1, N, Y, 10
CR2578038, 2, N, Y, 20
CR2578038, 3, Y, N, 30
CR2578038, 4, Y, N, 40
];

TEST_AGG:
Load CRNO,
sum(if(ONLINE='Y', MINUTES)) as ONLINE_MINUTES,
sum(if(DEGRADED='Y', MINUTES)) as DEGRADE_MINUTES
Resident TEST
GROUP BY CRNO
;

[qlikapple]

I am not gettting as excepted

The below one is original ouput which i want

Change Order Number	Disruptive change (Full)	Full Outage Minutes	Disruptive change (Degraded)	Degraded Outage minutes	Disruptive Free change	Incident Number
CR2574825	Y	331	N	22,447	N	IN44448108
as I have done that but I am getting like this
in the script, I have wriiten like this

Change Order Number	Disruptive change (Full)	Full Outage Minutes	Disruptive change (Degraded)	Degraded Outage minutes	Disruptive Free change	Incident Number
CR2574825	Y	331	N	22,447	N	IN44448108
as I have done that but I am getting like this
in the script, I have wriiten like this

[qlikapple]

HI ,

please find the attached , i am not getting the Output as expected, please find the first one which i need like this,  but i am getting like second one

can anyone please check

[qlikapple]

Anyone  please  check

[qlikapple]

please find the dummy data CRNO OUTSCOPE OUTAGEMINUTES IN NO 1234 ONLINE 32 11234 1234 DEGRADE 11234 2341 ONLINE 21 ABC 2341 DEGRADE 32 ABC 2341 ONLINE 43 ABC 123456 DEGRADE 21 2312 123456 DEGRADE 32 2312 123456 DEGRADE 21 2312 123456 ONLNE 21 2312 The requirement is like this , I want to show IN NO as single(unique) so that it should not repeat again , Now I want the o/p as CRNO OUTSCOPE(ONLINE Y) ONLINE MINUTES OUTSCOPE(DEGARDE Y) DEGRADE MINUTES IN NO 1234 Y 32 N 0 11234 2341 Y 21 Y 75 ABC 123456 Y 21 Y 74 2312