Need Help

[paulwalker]

Hi Community,

I have 2 QVD's i have more than 10 same fields.

How to handle that???

Please anyone help me....!!

PFA.

[francoiscave]

Hi Paul

USe Concatenate like below:

MI_Completes:

LOAD *

FROM (qvd);

Concatenate

View_MI_WIP:

LOAD *

FROM (qvd);

Have fun with QV,

François

[alexandros17]

If there is not a logical relation (E.g. Master-Detail) thden you can concatenate the 2 tables:

load ... from ...

concatenate

load ... from

Let me know

[reshmakala]

CONCATENATE would help.

[francoiscave]

Hi Paul,

Have you need some more help ?

If not, can you mark an answer as Correct or helpful to close this thread.

Thanks,

François

[paulwalker]

Hi Francois,

I have done concatenate, and i have created Calendar also..

when i reload script it showing error, script line error..

anything wrong in script..

[reshmakala]

Load Date($(vMinDate)+RecNo()-1) as TempDate

AutoGenerate $(vMaxDate) -$(vMinDate);

Here, there is no value coming up for $(vMinDate) causing nullvalue + RecNo() and so is a script line error

[paulwalker]

Actually i am getting date 07/01/2014.

but this is not Minimum date, actually i have 2013 data also..

[reshmakala]

What did you wnated to achieve by vMinDate+RecNo()-1??

[Peter_Cammaert]

The last error is probably caused by an empty vMaxDate variable. Only the -$(vMinDate) part remains, leading to a negative AUTOGENERATE value and that is not accepted as a valid count.

Check your variables. You better get Min/Max date values by using something like:

MinMaxTable:

LOAD Min(DateCompleted) AS MinDate, Max(DateCompleted) AS MaxDate

RESIDENT MI_Completes1;

and then peeking into the single record of this table to get correct values. Your current code depends on the correct ordering of one of your source tables (first/last row) and that may produce unpredictable results...