Using data from CSV

[ArtemZadorozhnyi]

Hi! 

My situation: I need to upload CSV file to Qlik Sense and then join it with data pulled from DB.

I've managed to upload CSV file:
Data load editor -> Data connections -> Attached files ->and then select local file to upload

Then in Data load editor created new section with this query:

merchants_list:
LOAD
  *
FROM [lib://AttachedFiles/T&A Global Cashback Hitlist  - Sheet9 (1).csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

On this stage data loads successfully and I can use it to build the app. 

But what I need is to use merchant_list in a query like this:

select * from p_tracking_affiliation_us_5y.breakage_recuperation br
join merhchnat_list on domain, market

Where p_tracking_affiliation_us_5y.breakage_recuperation - table in my database

 How do I make it work? 

Thanks! 

[Fabiano_Martino_Intelco]

Hi @ArtemZadorozhnyi 

you can use the JOIN clause with a loaded table.

Here you will find the details and some examples:

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

Regards

Fabiano

[ArtemZadorozhnyi]

It did work but in a weird way:
in the target table I have 2 columns: domain, market (table1)
in reference data set 3 columns: domain, market, marker (table2)

After running this ^ I was expecting table1 to be enriched with 'marker' from table2 based on domain and market, but instead I got this: 

Not sure how to make it work in a correct way