Exam QSDA2024 topic 1 question 26 discussion

Actual exam question from QlikView's QSDA2024

Question #: 26
Topic #: 1

[All QSDA2024 Questions]

Refer to the exhibit.

A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and change regularly. All csv files must be loaded into Qlik Sense for analysis.
Which method should be used to meet the requirements?

A. SET vFileList = 'Day1','Day2','Day3';
FOR EACH vFile in $(vFileList)
LOAD * FROM [lib://Data (User1) /multi/$(vFile).csv];
NEXT
B. LOAD *
FROM [lib://Data (User1)/multi/*]
(csv);
C. LOAD *
FROM [lib://Data (User1)/multi/*]
(txt)
D. SET vLib = chr(39) & 'lib://Data (User1)/multi/*.csv' & chr(39);
FOR EACH File in filelist($(vLib))
LOAD * FROM [$(File)];
NEXT

Show Suggested Answer

Suggested Answer: B 🗳️

by 7d737d9 at Nov. 22, 2024, 2:01 a.m.

Comments

Submit Cancel

Jdossa91

10 months, 1 week ago

Selected Answer: D

The aim is to automatically load all CSV files present in a directory where file names change regularly. To do this, you need to browse the files in the folder and load each one. Solution D is ideal for this task, as it uses Qlik functions to browse all .csv files in the specified directory: SET vLib = chr(39) & 'lib://Data (User1)/multi/*.csv' & chr(39); : This line defines the vLib variable, which contains the path to the folder where the CSV files are stored. The chr(39) is used to add single quotes around the file path, which is necessary in Qlik to process paths correctly. FOR EACH File in filelist($(vLib)) : The filelist() function generates a list of files matching the .csv template in the specified folder. LOAD * FROM [$(File)]; : This line loads the data for each file in the list. NEXT: This repeats the process for each file found in the directory Translated with DeepL.com (free version)

upvoted 1 times

...

shaan007

11 months, 1 week ago

Selected Answer: D

I tested this. D and A are working. but A will only load the listed file names ( Day1','Day2','Day3') D will load all .csvs

upvoted 1 times

...

7d737d9

1 year ago

The answer is wrong as the (csv) suffix is not valid. The row with the (txt) suffix is the correct answer.

upvoted 1 times

...