Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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);
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);
Hi Ruben
It works fine , thanks
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