Generate additional column/field on LOAD

[#1]

Hello,

I need to LOAD two xlsx tables. One holds data for year 2009, one for year 2010. Data structure is identical.

How do I create a new (pseudo-)field "Year" while I load the two tables and fill it with "2009" and "2010" at LOAD-time?

Best regards,

Georg

[tresesco · Accepted solution]

Hi,

If i have understood your requirement right, you can try this:

LOAD *, 2009 as Year FROM data2009.qvd;

//CONCATENATE

LOAD *, 2010 as Year FROM data2010.qvd;

[#3]

Thanks. that's what I needed.

I just needed single quotes .... '2009' as Year.

Tried it "2009" before but that was interpreted as a field name.

Best regards,

Georg