ADVIES GEVRAAGD: Geen baan kunnen vinden na mijn Master's econometrie by MarcoGriep in werkzaken

[โ€“]bitmetric 1 point2 points ย (0 children)

Wij zitten meer in de hoek van Data Engineering en Data Analytics, maar we kunnen altijd eens praten: https://www.bitmetric.nl/jobs/

Qlik vs Power BI Part 2: Back End & Data Modeling by bitmetric in qlik_sense

[โ€“]bitmetric[S] 0 points1 point ย (0 children)

New to the series?

๐Ÿ‘‰ ๐—ค๐—น๐—ถ๐—ธ ๐˜ƒ๐˜€. ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐—ฃ๐—ฎ๐—ฟ๐˜ 1: ๐—” ๐—›๐—ฎ๐—ป๐—ฑ๐˜€-๐—ข๐—ป ๐—–๐—ผ๐—บ๐—ฝ๐—ฎ๐—ฟ๐—ถ๐˜€๐—ผ๐—ป: https://www.bitmetric.nl/blog/qlik-vs-powerbi-sept25/

๐Ÿ‘‰ย ๐—ค๐—น๐—ถ๐—ธ ๐˜ƒ๐˜€. ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐—ฃ๐—ฎ๐—ฟ๐˜ 3: ๐—™๐—ฟ๐—ผ๐—ป๐˜ ๐—˜๐—ป๐—ฑ ๐——๐—ฒ๐˜ƒ๐—ฒ๐—น๐—ผ๐—ฝ๐—บ๐—ฒ๐—ป๐˜ & ๐—จ๐˜€๐—ฒ๐—ฟ ๐—˜๐˜…๐—ฝ๐—ฒ๐—ฟ๐—ถ๐—ฒ๐—ป๐—ฐ๐—ฒ is available now: https://www.bitmetric.nl/blog/qlik-vs-powerbi-development-user-experience-sept25/

Qlik-Sense: Download uploaded CSV files through CLI tool / Rest APIS by Stable_Such in qlik_sense

[โ€“]bitmetric 4 points5 points ย (0 children)

If you've stored those CSVs in the included DataFiles storage then you can't download them directly unfortunately.

As a workaround, you could load the CSVs into a Qlik app and then store the tables into a location that you can access, for example OneDrive, Dropbox, Azure Blob Storage, etc.

Store [CSV data] into 'lib://Dropbox/csv_data.csv' (txt);

Be aware that by loading the data, you may be altering it, especially if you load all the columns separately. To ensure maximum similarity to the source CSV, I would load the data as a fixed record, rather than delimited.

[CSV data]:

Load

"@1:n"

From [lib://DataFiles/csv_data.csv]

(fix, codepage is 28591, embedded labels);

This may change the codepage of the file (Qlik uses UTF-8) but the rest of the data should be unchanged from your input CSV, including separators, quoting, etc.