-
Stefan WALTHER
A big QlikView / Qlik Sense fan and always trying to push the boundaries of these two products with several integration techniques.
more Get Updates !
-
Recent Articles
- Using Bootstrap CSS in Qlik Sense Visualization Extensions
- Funnel Chart Visualization Extension for Qlik Sense
- MediaBox Visualization Extension for Qlik Sense
- Calendar Heatmap Visualization Extension for Qlik Sense
- QR Code Visualization Extension for Qlik Sense
- Generate Your Qlik Sense Extension in Less Than 2 Minutes
- See you there?: Hackathon@Qonnections2014
- Improvements to WebPageViewer2 QlikView Extension
- SlopeGraph for QlikView (D3SlopeGraph QlikView Extension)
- Calendar Heatmap QlikView Extension (D3CalendarView)
Categories:
- QlikChallenge (1)
- QlikTips (41)
- QlikView 9 (4)
- QlikView 10 (10)
- QlikView 11 (12)
- QV Server/Publisher (6)
- Creating Applications (18)
- Charts (4)
- Design & Layout (11)
- End User Experience (8)
- Development /QV Developer (46)
- APIs (6)
- QmsApi (2)
- Extensions (25)
- Integration (8)
- Load Scripts (9)
- Macros (6)
- Settings (3)
- APIs (6)
- News (15)
- Nice Read (8)
- QlikView News (5)
- Site News (2)
- SysAdmin/Installation (7)
- QlikView-Online-Tools (3)
- German Articles (25)
- Strategy (3)
- Technology News (1)
- Fun (1)
- Qlik Sense (6)
QlikTip #3: Check whether a field exists or not (translated and improved)
This entry was posted in Load Scripts, QlikTips
If you want to load all fields in a table or a QVD file in loading scripts (so typically
SELECT * FROM...
scenarios), it is often necessary to know whether a field (within a table) exists or not.The following code example demonstrates how this can be achieved:
Explanation:
The function
FieldNumber
returns 0 if a field does not exist.Simplification for better reuse:
By using a “user defined function” (UDF) we can simplify the code above for easier reuse:
The original german version of this article can be found here.
Possibly related posts:
Dieser Beitrag zeigt, wie man in einem Lade-Script feststellen kann, ob ein Feld in einer bereits geladenen Tabelle existiert oder nicht....
STORE INTO konnte bis dato zur Speicherung einer Tabelle in eine QVD-Datei verwendet werden. // Store table Customers into Qvd-file STORE Customers INTO Customers.qvd (qvd); Dabei ist (auch in vorherigen Versionen) der Parameter nach dem...
In some delta-load scenarios it may be necessary to delete specific QVD files from within your load-script (QVD-Generator). This article shows three completely different ways to achieve that goal....
and tagged field, FieldNumber, udf, user defined function. Bookmark the permalink. Both comments and trackbacks are currently closed.