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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.