topic Using data from CSV in App Development

Using data from CSV

ArtemZadorozhnyi — Fri, 05 Jul 2024 15:14:53 GMT

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!

Re: Using data from CSV

Fabiano_Martino_Intelco — Fri, 05 Jul 2024 16:11:33 GMT

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/Join.htm

Regards

Fabiano

Re: Using data from CSV

ArtemZadorozhnyi — Fri, 05 Jul 2024 17:06:30 GMT

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