Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to resolve this loops

How to resolve the loops?

Thanks in advance.

Age_group:
LOAD `age_group_id`,
    `age_min`,
    `age_max`,
    `age_range`;
SQL SELECT *
FROM `C:\Island Marketing\club`.`Age_group`;

City:
LOAD `city_id`,
    city,
    `region_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.City;

Country:
LOAD `country_id`,
    country;
SQL SELECT *
FROM `C:\Island Marketing\club`.Country;

LOAD `cust_id`,
    `first_name`,
    `last_name`,
    age,
    `phone_number`,
    address,
    `city_id`,
    `sales_id`,
    `sponsor_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Customer;

Customer:
LOAD `inv_id`,
    `service_id`,
    days,
    `nb_guests`;

Invoice_Line:
SQL SELECT *
FROM `C:\Island Marketing\club`.`Invoice_Line`;

LOAD `region_id`,
    region,
    `country_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Region;

Region:
LOAD `sl_id`,
    `region_id`,
    `sales_revenue`;
Region_SLine:
SQL SELECT *
FROM `C:\Island Marketing\club`.`Region_SLine`;

LOAD `res_id`,
    `service_id`,
    `res_days`,
    `future_guests`;
Reservation_Line:
SQL SELECT *
FROM `C:\Island Marketing\club`.`Reservation_Line`;

LOAD `res_id`,
    `cust_id`,
    `res_date`;
Reservations:
SQL SELECT *
FROM `C:\Island Marketing\club`.Reservations;

Resort:
LOAD `resort_id`,
    resort,
    `country_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Resort;

Sales:
LOAD `inv_id`,
    `cust_id`,
    `invoice_date`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Sales;

Sales_Person:
LOAD `sales_id`,
    `sales_person`;
SQL SELECT *
FROM `C:\Island Marketing\club`.`Sales_Person`;

Service:
LOAD `service_id`,
    service,
    `sl_id`,
    price;
SQL SELECT *
FROM `C:\Island Marketing\club`.Service;

Service_Line:
LOAD `sl_id`,
    `service_line`,
    `resort_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.`Service_Line`;
//-------- End Multiple Select Statements ------


Capture.JPG.jpg

10 Replies
Not applicable
Author

Thank you Kunal.