Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Renaming / Mapping date fields for calculation

Hello community,

couldn't think of a better title

I have a database table with field names of COL1 to COL(n). Via a mapping table I assign new column names, which looks like below example:

OLDNAME  NEWNAME

COL1 [Vol 2009]

COL2 [Vol 2010]

COL3 [Vol 2011]

COL4 [CoS 2009]

COL5 [CoS 2010]

COL6 [CoS 2011]

COL7 [PAPU 2012]

COL8 [PAPU 2013]

COL9 [PAPU 2014]

FieldNameMap:

Mapping LOAD OLDNAME, NEWNAME

FROM

MappingTable.xlsx

(ooxml, embedded labels, table is Sheet1);

Rename Fields using FieldNameMap;

Now I need those columns to correspond with a year field so that when for example the year 2009 is selected I can make calculations for Vol 2009 and CoS 2009.

Not all of my columns have the same start and end year as you can see in the example above.

What do I need to do to get this done? Do I need to change my Mapping table?

Thank you.

1 Reply
Not applicable

Re: Renaming / Mapping date fields for calculation

wow 2 hits within 24 hours - new moderation feature is killin

So now I need to bump the thread and hope for hits?

Community Browser