Assign Months to field values based on previous column header position

[#1]

Hi everyone, I am new to Qlikview and this site. I am hoping someone can suggest how I can assign month names (i.e. "Jan--09") to field values. This data is coming in from a transposed Text file, where the field values in the "month" column correspond only to their previous column header position. The table only contains the most recent 24 months of data at any given time.

I can automatically extropolate the current DataMonth. And I know I can build on this using the "addmonths" function, but I'm not sure how to rename the fields using this information. Thank you, I appreciate any help you can offer.

[#2 · Accepted solution]

J-rawk,

Welcome to the Community! We're glad to have you.

As far as your question goes, I'm not quite sure I understand, but I'll do my best to help (I'm only the Community Manager, all of the technical QV gurus must have a life on weekends )

It sounds like you have the function worked out, you just want to rename the field in the load script? Here's an example where I perform a function on a field called "Joined" and rename it "Weekday":

weekday(floor(Joined)) as Weekday,

Is that what you were looking for?