Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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' ?