Qlik_073: How to get Metadata of all QVDs from any folder.
Вставка
- Опубліковано 3 сер 2024
- In this video, we will see how can we load metadata of all QVDs from any folder.
00:00:01 - 00:00:55 Introduction of Metadata.
00:00:56 - 00:01:15 Create a test data QVD.
00:01:16 - 00:05:50 Get metadata of single QVD
00:05:51 - 00:25:17 Get metadata of multiple QVDs using for loop.
If you want to read about QVD Metadata functions like QVDCreateTime, QVDNoOfFields, QVDNoOfRecords, QVDTableName
help.qlik.com/en-US/sense/Feb...
Download content of this video
drive.google.com/file/d/15bYS...
You can also find me on
UA-cam: / @manishkumarkachhia1683
Facebook: profile.php?...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: www.udemy.com/user/manish-kac...
#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #Genericload #fieldvaluecount #fieldvalue #tablename #loop #forloop #variableswithparameter #aggr #firstsortedvalue #Textbetween #QlikExtension #Extension #QVDMetaData
Very powerful, highly useful and well explained. This is the case with all of your videos. You are a gifted teacher and presenter and I totally appreciate the succinctness of your efforts.
You Sir, are a genius, Love your work.
Excellent explanation
We are so lucky for having your classes tq sirr. 😊
Your videos are super . please make as a course or full length it is make very useful. Like me . please note this
Hi Manish, I am very impressed about you videos. All videos are very helpful while cracking the interview.Can you please help me how to get all qvd meta data all qvd s from one connection.
Also good to know if we can connect the table name to the field name in each file
Awesome stuff Manish. Is there a way to get the calculation used in Master measures?
Very Nice and Informative Video. Is there any way to match the App ID with the name? to make tracking easier
Yes that is what i need.
@@sarahdanenberg68 I just created a way for getting the same, do let me know if someone needs it, will create a way for the same.
Hi Manish,
Thank you for your efforts..
I have one requirement.
When we export table data into excel. The Total row not added in exported excel file.. Do you have any idea about resolve this issue.
Please help me on this..
Can you share the script used in notepad please?