Discussion board where members can get started with Qlik Sense.
I need to upload a file only if the file name is equals to a value in another table.
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.
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' ?