Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Load comparing two table

Hi everyone,

I need to upload a file only if the file name is equals to a value in another table.

For example:

File Name --> ACT20170102 - 2017010201.xlsx

                         Terna             -       Periodico

And i have a TABLE "HISTORY" where there are 2 columns about files that I have just uploaded previously: Terna and periodico.

I'd like upload files that aren't in TABLE "HISTORY" because the file name contains the couple TERNA and PERIODICO.



1 Reply

Re: Load comparing two table

Is the file name in the already loaded table split into two fields - Terna and Periodico? But the full file name is

'ACT20170102 - 2017010201.xlsx' ?