I have the following text files that I need to bring into a qvw. I wasn't sure how to do it.
The format of them is the same and I will be getting a new one every month which means this will have to take from all files with, say, CICS* in the name so I don't have to import the new one every month. All I want to have to do is put the new file in the folder with all of these files.
I need the "DATE", "# of T/XS" and "AVG RSP" column. The last column can be calculated if need be.
I don't need the Totals either. Those can be calculated. Just the raw data.
Like when you use a Left Join or contatenate to bring all the data into one table instead of having it be in separate tables. Right now each file ends up being in its own table. I want it all in one so I can call, for example, "DATE" field and get all the dates.
The automatic join between fields with the same name in different tables can be suspended by means of the qualify statement, which qualifies the field name with its table name. If qualified, the field name(s) will be renamed when found in a table. The new name will be in the form of tablename.fieldname. Tablename is equivalent to the label of the current table, or, if no label exists, to the name appearing after from in load and select statements.
Qualification is always turned off by default at the beginning of script execution. Qualification of a field name can be turned on at any time using a qualify statement. Qualification can be turned off at any time using an unqualify statement.