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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data LOAD from multiple tables

Please see attached file for all the tables and fields.

MARGIN_FACT and POSITION_FACT are concatenated.

I need to produce a table with the following fields:

- Exhange

- Contract Code

- Contract Description

- Aggregate Quantity

- Initial Margin

All this data comes from multiple tables which are linked in a complex way (you can see in the attached file).

I am trying to write the LOAD code to load all the needed fields so that I would be able to create the straight table. However, I tried many ways but there's always some problem, either a field is not showing or showing wrong data.

Please could anyone give me any advice.

10 Replies
Not applicable
Author

See attached file, I can't upload other tables as I still keep getting that error.