Looping and Qualify load in Qlikview

Question

I want to create two tables in qlikview; one called Station and one called Trains. I had planned to apply a QUALIFY statement so any matching fields between the two tables are not confused.

However, the data for each table are loaded in from multiple spreadsheets using a FOR EACH ... loop. This means that by qualifying the load, multiple tables are created called: Station-1, Station-2, Station-3, etc. with similarly sequential field names.

Is there a way I can semi-QUALIFY my load statement, so that all the all fields are preceeded with either "Station." or "Trains." without having a different name applied to data coming from each individual spreadsheet?

I love a simple answer. Thanks @oGeez . Saves me lots of manual typing. — Hal Baggot, Apr 11 '14 at 11:30
If *oGeez* gave a good answer you should vote it up and select it as valid answer. — smartmeta, Jun 18 '14 at 12:51
Indeed, I will (I think they originally posted it as a comment, otherwise I would have done it at the time) — Hal Baggot, Jun 18 '14 at 12:57

score 3 · Accepted Answer · answered May 20 '14 at 10:45

3

Concatenate your station tables before qualifying the column names.

Something like the following:

[Station]:
  LOAD [col1], [col2]
  FROM [Station1.xls]

[Station2]:
  CONCATENATE (Station)
  LOAD [col1], [col2]
  FROM [Station2.xls]

answered May 20 '14 at 10:45

George

36,413
9
66
103

score 1 · Answer 2 · answered Jan 05 '15 at 20:20

I would try to avoid qualify in general. For many scenarios, common fields among different tables tells you something about the date, where Qualify helps you ignore.

What sort of association do you want between the trains and station tables? Make sure you understand QVs association engine as well as the fields you want to interrelate.

Also - Concatenate will do a nice looking union as long as the field names are identical. In fact, it will automatically concatenate if there exist the same number of fields with the same names. If this is not the case, you're probably better off setting variables using if() statements to combine common fields with different names.

i.e. IF Match('$(vFieldName)', 'FUELCODE' ) then SET vFuel = 'FUELCODE'; ELSEIF Match('$(vFieldName)', 'FLDCD_TR' ) then SET vFuel = 'FLDCD_TR'; ENDIF

Best, David

In this case, I wanted no association between trains and stations. In an ideal world it would have bene two separate dashboards but having both data sets in one application was less confusing for the end user (and required fewer licences) — Hal Baggot, Jan 30 '15 at 09:26

Looping and Qualify load in Qlikview

2 Answers2