loop through data to get all variations.

hopkinsc — Thu, 17 May 2012 08:56:21 GMT

Hi everyone.

I need help with writing a script to read through my data and generate a new table for all variations .

Here is a sample of how the data looks

CC From CC To EC From EC To Description

01051	01061	854-	890-	Servicemen
01205	01205	850-	852-	Servicemen
01205	01205	854-	890-	Servicemen
01008	01009	853-	853-	Materials and consumables
01008	01009	901-	928-	Materials and consumables
01008	01009	931-	944-	Materials and consumables
01008	01009	905-	913-09	Materials and consumables
01008	01009	957-	957-	Materials and consumables
01008	01009	963-	981-	Materials and consumables
01012	01012	853-	853-	Materials and consumables
01012	01012	901-	928-	Materials and consumables

So what i want to do is get all variations of CC From - CCTo in one field rather than 2.

the first line is 01051 01061, so in the new field i would have the following..

01051

01052

01053

01054

01055

01056

01057

01058

01059

01060

01061

Then loop through again to do line 2 etc etc

I need all of the relationships still to be there too, so when 01053 is selected, i still want to see EC details from 854-890 and for servicemen.

I want to do the same for ECFrom and ECTo but these fields contain additional characters.

905 to 913-09 , i would need a table containing

905

906

907

908

909

910

911

912

913-00

913-01

913-02

913-03

913-04

913-05

913-06

913-07

913-08

913-09

Can anyone help please? .

loop through data to get all variations.

Jason_Michaelides — Thu, 17 May 2012 09:47:00 GMT

You seem to have posted the same question twice. See my comment on the other one -

http://community.qlik.com/thread/50519

loop through data to get all variations.

hopkinsc — Thu, 17 May 2012 09:51:41 GMT

Yes i have, i wasn't sure of the best place to put it.

loop through data to get all variations.

Jason_Michaelides — Fri, 18 May 2012 13:58:57 GMT

Can you close or delete this one please?

topic loop through data to get all variations. in QlikView

loop through data to get all variations.

loop through data to get all variations.

loop through data to get all variations.

loop through data to get all variations.