topic Generate additional column/field on LOAD in QlikView

Generate additional column/field on LOAD

Wed, 28 Jul 2010 09:36:45 GMT

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

tresB — Wed, 28 Jul 2010 09:58:46 GMT

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;

Wed, 28 Jul 2010 10:30:26 GMT

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