Fieldname() function causing trouble - was working already

datanibbler — Tue, 28 Apr 2015 10:18:56 GMT

Hi,

I am just building an app that is actually like one I had already, only based on a new list with a new layout.

The columns in this list are fixed up to column 36 (AJ) which is labeled "Betriebsstunden April 2015".

At this point, one new column will be added every month -> there will be 8 more coming.

I have a loop (that I had in the old vrs. and that was working fine there) that does the following:

- All the columns from 36 to 44 (8 more months to go) are parsed.

- Each one is assigned a fieldname (using that function in QlikView) like >v_field_37<

- Depending on the fieldname, it is assigned one of two alias_names

- either > dummy_37 < (if there is no relevant data)

- or sth. like > BS_May_15 < (if there is)

The problem is, now the fieldname() function (which I wrap into square brackets, like

>> chr(91)& Fieldname($(i), 'Masterliste_Stapler_64')&chr(93) <<

returns an empty string.

=> The remainder of the loop of course cannot work correctly.

The field nr. 37 would be labeled >> operating hours <<, so the square brackets should do, no?

Can someone help me here? It used to work just like that, so I'm a bit dumbfounded now.

Thanks a lot!

Best regards,

DataNibbler

Re: Fieldname() function causing trouble - was working already

datanibbler — Tue, 28 Apr 2015 10:26:59 GMT

This is done 😉

I compared what I have now to my old code and realized I have to load all the column_headers first.

Easy once you have found out - like Columbus' egg 😉