Load and Store Statements

[#1]

Hello Community,

Do I have to load the table first before I can place a store statement in the script? Attached is a sample script on a word doc.

Another question I have is when I run the debugger it shows:

2008<<QV DSS 08

2008<<QV DSS 09

2008<<QV DSS 10

Shouldn't the first part with the table names so it reads:

2008<<QV DSS 08

2009<<QV DSS 09

2010<<QV DSS 10

I am open to opinions on structuring my tables I have just been pulling annual reports from Crystal and loading txt files.

Thank you,

EK

[#2]

To which option do you refer? 1 ot 2?

[farolito20]

First    

[#4]

Add to the table the next field:

load Name,

ID,

Age,

Now() AS Date

from XXX;

and each row will have the date and time of the loading time..

Goodluck!

[#5]

In the first option table1 should be dropped (as attached). follow the script:

table1:

Load ID,

        Name,

        Age

from table 1

Load ID,

        Name,

        Age

from table2

and then use the distinct command

noconcatenate

Table2:

load distinct

        ID,

        Name,

        Age

resident Table1;

Drop Table1;

store table2 into XXX.qvd(qvd); //now Table2 will hold rows of both tables only once for duplicates.

[farolito20]

In table 2 LOAD?

[#7]

In this part:

noconcatenate

Table2:

load distinct

        ID,

        Name,

        Age,

        now() as Date

resident Table1;

Drop Table1;

store table2 into XXX.qvd(qvd);

[farolito20]

tabla1:

LOAD ID,

     Name,

     Age

FROM prueba.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD ID,

           Name,

           Age

FROM tabla1.qvd (qvd);

NoConcatenate

tabla2:

LOAD Distinct

          ID,

           Name,

           Age,

           Now() AS Date

Resident tabla1;

STORE tabla2 into bk.qvd (qvd);

[farolito20]

all dates were modified

[#10]

drop table1 before the 'STORE' command.

Modified? to what?

[farolito20]

When I put drop1 tabla1 give an syntax error