CONCATENATE

[#1]

I HAVE A PROBLEM WITH THE CONCATENATE ACTION. I´M TRYING TO CONCATENATE TWO QVD, WITH THE SAME NUMBER AND NAME OF FIELDS. I´M RELOADING WITH LIMITED LOAD OF 10. THE RESULT OF THIS CONCATENATE, THROW ME 30 REG. SOMEBODY CAN EXPLAIN ME, WHY DO I HAVE 30 AND NOT 20 REG? THANKS. LUCIANO STRAFACE

[#2]

can you post your script, so we can have a look?

Rey-man

[#3]

TEMP:

LOAD

MAKEDATE(LEFT(Fecha,4), MID(Fecha,5,2), RIGHT(Fecha,2)) AS Fecha

FROM

maestrousu.qvd (qvd);

concatenate

LOAD

Fecha

FROM

VISA_MAESTRO_USUARIOS_HIST_CITI.QVD (qvd); THANKS

[#4]

Try this

TEMP:

LOAD
MAKEDATE(LEFT(Fecha,4), MID(Fecha,5,2), RIGHT(Fecha,2)) AS Fecha
FROM maestrousu.qvd (qvd);

concatenate (TEMP)

LOAD
Fecha
FROM VISA_MAESTRO_USUARIOS_HIST_CITI.QVD (qvd);

Talha

[#5]

I try and I have the same result. If I change de order of the load, I have 20 reg. I dont understand why.

Thanks

Luciano

[Anonymous]

Can't se from the script that the number of records is limited on load.
What I'm missing?

[Oleg_Troyansky]

perhaps the script is being run via Debugger... it might be a glitch in the debugger and the "limited load"
function. Try loading the whole table ans see if you get the same problem.

[#8]

I load the whole table and I dont have the problem. But the size of the qvd is bigger than logic.

I have this two qdv:

VISA_MAESTRO_USUARIOS_HIST_CITI.QVD

1679000 kb

maestrousu.qvd

220406 kb

And the size of the qvd resulting its 3031737 kb. Is this normal?

[Oleg_Troyansky]

Well, it's hard to operate with KB instead of the number of rows...Would be better if you could get the row counts from all the QVD files and compare them.

However, it doesn't sound right. Examine your script once again:

1. Do you have the same statement repeated twice by mistake?

2. Do you have a previous statement that loads the same set of fields, causing unexpected concatenation?

cheers,

[#10]

The number of rows of the qvd resulting its the same that if I add the number of rows of the two qvd that I´m trying to concatenate.

The names of the fields are the same in the original qvds.

The number of the fields are the same in the original qvds.

Do you know why is this happening?