Array to QVD

[#1]

Hi

I have two array variables and aI need one qvd file wiht this two variable somethilng like this:

vLocal = "?Recife?Rio de Janeiro?Sao Paulo?Salvador"

vGerente="?Carlos Afonso?Thiago Jose?Antonio Carlos?Katia Maria"

And I need a qvd file like

Local                     Gerente

Recife                    Carlos Afonso

Rio de Janeiro         Thiago Jose

Sao Paulo               Antonio Carlos

Salvador                  Katia Maria

How can I do this?

[rubenmarin · Accepted solution]

Hi Luiz Fernando, you can use an script like this:

SET vLocal = "?Recife?Rio de Janeiro?Sao Paulo?Salvador";

SET vGerente="?Carlos Afonso?Thiago Jose?Antonio Carlos?Katia Maria";

LET vNumValues=SubStringCount('$(vLocal)', '?');

For i=2 to vNumValues+2

    data:

    LOAD SubField('$(vLocal)', '?', $(i)) as Local,

        SubField('$(vGerente)', '?', $(i)) as Gerente

    AutoGenerate 1;

next

STORE data into data.qvd(qvd);

[#3]

Hi Ruben

It works fine , thanks

[rwunderlich]

You don't need a FOR loop. If you use only two parameters to subfield(), QV will automatically generate mutiple rows.

    data:

    LOAD SubField('$(vLocal)', '?') as Local,

        SubField('$(vGerente)', '?') as Gerente

    AutoGenerate 1;

-Rob

http://masterssummit.com

http://robwunderlich.com