ExamTopics Logo
Mail Us[email protected]
Menu
Qlikview Discussions
exam questions

Exam QSDA2024 All Questions

View all questions & answers for the QSDA2024 exam
Go to Exam

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 Hide Answer
Suggested Answer: B 🗳️
by 7d737d9 at Nov. 22, 2024, 2:01 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Jdossa91
3 months 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
4 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
5 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago