Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

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.

Thanks,

Livio

1 Reply
MVP
MVP

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' ?