Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have read that there are things that are easy to do in Qlik Script but hard to do in SQL (ETL: Qlik Scripting vs Sql query | Qlik Community). Does anyone have good examples of this?
I have been working with Qlik for a while, but have less experience with SQL and am curious as to how they compare.
Best regards
Rean
Qlik Script has a number of features designed to server the specialized requirements of Qlik Transformation and Dimensional Modeling. A few things that come to mind that are easy in Qlik but harder in SQL:
1. MAPPING. Whether data mapping or "RENAME FIELDS USING mapname" the Qlik solution is simple and elegant.
2. IntervalMatch.
3. Qlik Script provides more Datetime functions than a typical SQL implementation. For example, "InYearToDate()".
-Rob