topic Re: qlikview script to transform structures in QlikView

qlikview script to transform structures

Froyo — Sat, 16 Nov 2024 01:19:11 GMT

Good morning How can I get this result from the qlikview script?

Source Table

Pos CTASTART CTAEND Status

52 5720000 5720000 X

55 4000000 4000999 S // Example, records to create from 4000000 to 4000999

76 4300001 4300002 U

Qvd destination

Pos CTA Status

52 5720000 X

55 4000000 S

55 4000001 S

55 4000002 S

55 ... S

55 4000999 S

76 4300001 U

79 4300002 U

Thanks for your help

Re: qlikview script to transform structures

marcus_sommer — Mon, 10 Feb 2020 10:25:29 GMT

Take a look here: IntervalMatch

- Marcus

Re: qlikview script to transform structures

Taoufiq_Zarra — Mon, 10 Feb 2020 11:16:52 GMT

maye be

Script :

Data: load num(CTAEND-CTASTART) as NB,* inline [ Pos,CTASTART,CTAEND,Status 52,5720000,5720000,X 55,4000000,4000999,S 76,4300001,4300002,U ]; output: LET NumRows=NoOfRows('Data'); FOR i=0 to $(NumRows)-1 LET vPos=Peek('Pos','$(i)','Data'); LET vCTASTART=Peek('CTASTART','$(i)','Data'); LET vCTAEND=Peek('CTAEND','$(i)','Data'); LET vStatus=Peek('Status','$(i)','Data'); let Numsubrow=Peek('NB','$(i)','Data'); for ii=0 to '$(Numsubrow)' load '$(vPos)' as New_Pos,'$(vCTASTART)'+'$(ii)' as CTA, '$(vStatus)' as New_Status,'$(i)' as i,'$(ii)' as ii autogenerate 1; Next Next drop table Data; drop field i,ii;

output:

Re: qlikview script to transform structures

Froyo — Mon, 10 Feb 2020 17:18:50 GMT

Thank you, I will try to do it

Re: qlikview script to transform structures

rwunderlich — Mon, 10 Feb 2020 18:03:00 GMT

IntervalMatch() as Marcus suggested or:

Data:
Load
Pos,
CTASTART + IterNo() - 1 as CTA,
Status
inline [
Pos,CTASTART,CTAEND,Status
52,5720000,5720000,X
55,4000000,4000999,S
76,4300001,4300002,U
]
While CTASTART + IterNo() - 1 <= CTAEND;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com