EXP_F_EXPENSE]: LOAD 1 AS "DATE_KEY", 1 as "COMPANY_KEY", 1 as "ACFT_KEY", 1 as "AIRCRAFT_UNIT_KEY", 1 as "GL_ACCOUNT_KEY" AS "EXP_FACT_GL_ACCOUNT_KEY", 1 as "INV_KEY", 1 as "INV_LINE_ITEM_KEY", 1 as "FLEET_KEY", 1 as "LOCATION_KEY", 1 as "FACT_SK", 1 as "ORD_LINE_ITEM_KEY", 1 as "SERVICE_LOCATION", 1 as "SUPPLIER_LOCATION", 1 as "ORD_KEY", 1 as "SUP_ITEM_KEY", 1 as "ATA_KEY", 1 as "SUP_KEY", 1 as "EXP_CLASS_CD" AS "EXP_FACT_EXP_CLASS_CD", 1 as "EXP_DIVISION_CD" AS "EXP_FACT_EXP_DIVISION_CD", 1 as "EXP_COST_ROLLUP_CD" AS "EXP_FACT_EXP_COST_ROLLUP_CD", 1 as "EXP_COST_ACCOUNT_CD" AS "EXP_FACT_EXP_COST_ACCOUNT_CD", 1 as "EXP_COST_SUBCATEGORY_CD", 1 as "INVOICED_RATE", 1 as "INVOICED_QUANTITY", 1 as "INVOICE_LINE_TOTAL", 1 as "DISPUTED_AMOUNT", 1 as "CLAIM_LINE_ITEM_SUM", 1 as "DEBIT_LINE_ITEM_SUM", 1 as "CREDIT_LINE_ITEM_SUM", 1 as "ACTUAL_EXPENSE", 1 as "ACCRUAL_EXPENSE", 1 as "GRAND_TOTAL_EXPENSE", 1 as "ACCRUAL_IND", 1 as "DISTRIBUTED_DT", 1 as "APPROVED_DT" 1 as FROM "EXP_F_EXPENSE"; 1 as [EXP_D_DATE]: 1 as SELECT "DATE_KEY", 1 as "DATE_KEY" AS "GL_DATE_KEY", 1 as "COMPANY_KEY" AS "COMPANY_KEY_DATE", 1 as "DATE_VALUE", 1 as "DAY_OF_WEEK_NBR", 1 as "DAY_OF_WEEK_DESC", 1 as "DAY_OF_WEEK_SHORT_DESC", 1 as "WEEK_END_FLG", 1 as "WEEK_IN_MONTH_NBR", 1 as "WEEK_IN_YEAR_NBR", 1 as "WEEK_START_DT", 1 as "WEEK_END_DT", 1 as "DAY_OF_MONTH_NBR", 1 as "MONTH_VALUE", 1 as "MONTH_DESC", 1 as "MONTH_SDESC", 1 as "MONTH_START_DT", 1 as "MONTH_END_DT", 1 as "DAYS_IN_MONTH_NBR", 1 as "LAST_DAY_OF_MONTH_FLG", 1 as "DAY_OF_QUARTER_NBR", 1 as "QUARTER_VALUE", 1 as "QUARTER_DESC", 1 as "QUARTER_START_DT", 1 as "QUARTER_END_DT", 1 as "YEAR_QRTR_VALUE", 1 as "ACC_QRTR_VALUE", 1 as "ACC_YEAR_MONTH_VALUE", 1 as "ACC_YEAR_VALUE", 1 as "LAST_DAY_OF_QUARTER_FLG", 1 as "DAY_OF_YEAR_NBR", 1 as "YEAR_VALUE", 1 as "YEAR_MONTH_VALUE", 1 as "PRIOR_YEAR_VALUE", 1 as "PRIOR_YEAR_QRTR_VALUE", 1 as "PRIOR_QRTR_VALUE", 1 as "FIRST_DAY_OF_MONTH_FLG", 1 as "FIRST_DAY_OF_WEEK_FLG", 1 as "FIRST_DAY_OF_QRTR_FLG", 1 as "FIRST_DAY_OF_YEAR_FLG" AUTOGENERATE 0;
[EXP_D_INVOICE]: LOAD 1 as "INV_KEY", 1 as "INV_KEY" AS "GL_INV_KEY", 1 as "BATCH_KEY", 1 as "COMPANY_KEY" as "COMPANY_KEY_INVOICE", 1 as "SUPPLIER_KEY", 1 as "INV_SOURCE_NM", 1 as "SUPPLIER_INV_NBR", 1 as "INV_SUBJECT_AREA_DESC", 1 as "INV_TYPE_DESC", 1 as "INV_CREATE_DT", 1 as "INV_CREATED_BY_USERNM", 1 as "INV_DT", 1 as "INV_STATUS_CD", 1 as "INV_STATUS_NM", 1 as "INV_APPROVED_DT", 1 as "BATCH_TRANSFER_ID", 1 as "INV_LOCATION_KEY", 1 as "REMIT_TO_VENDOR_ID", 1 as "FR_GL_POSTED_DT", 1 as "GMP_COVERAGE_YRMO", 1 as "GMP_TRANS_YRMO" AUTOGENERATE 0;
[EXP_F_GL]: LOAD 1 as "GL_KEY", 1 as "GL_ACCOUNT_KEY", 1 as "SUP_KEY" AS "GL_SUP_KEY", 1 as "INV_KEY" AS "GL_INV_KEY", 1 as "DATE_KEY" AS "GL_DATE_KEY", 1 as "ACFT_KEY" AS "GL_ACFT_KEY", 1 as "COMPANY_KEY" AS "GL_COMPANY_KEY", 1 as "FLEET_KEY" AS "GL_FLEET_KEY", 1 as "GL_ACCOUNT_NBR", 1 as "EXP_CLASS_CD", 1 as "EXP_DIVISION_CD", 1 as "EXP_COST_ROLLUP_CD", 1 as "EXP_COST_ACCOUNT_CD", 1 as "INV_NBR", 1 as "VENDOR_ID", 1 as "GL_ENTRY_DT", 1 as "GL_POSTED_DT", 1 as "INV_DT" AS "GL_INV_DT", 1 as "EXPENSED_AMOUNT", 1 as "CREDIT_AMOUNT" AUTOGENERATE 0
Qlikview associates tables by the names they have in common. By giving fields different names in both tables it won't be used to associate the tables. So renaming fields can break a loop. That's what you need to do. Rename fields.
