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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

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
petter
Partner - Champion III
Partner - Champion III

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