Hi All, The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements. LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET v...
Hi all beloved Qlikers, I will get monthly Excel reports which contain more than 10 sheets. Is there anyways to load all sheets in 1 script? The problem here is there is no header from Sheet 2 o...
I'm trying to work with a file that comes from an industrial computer. Before I can import into my Qlik application, I need to figure out how to handle the multipleheader rows and data that u...
Hi,
I have an excel file with multipleheaders, kindly suggest how can i read this
File looks like above
please suggest any workaround to read this file
R...
Hi! I have the following problem: I have to load data from multipleexcel files (one file is created each period). The period field is presented in a single cell in the header of each excel file....
Hi everyone, I came to an issue regarding creating a treemap. I need to group the headers and sub-calculations.In the attached excel file, I have shown the raw data to the sorted data t...
I've seen multiple posts about this topic, but couldn't find an answer for my case. I have an Excel file with a lot of headers in an inconsistent way in the file. Is there any way to read this in Q...
Hi All, I need to extract specific cells in multiple sheet (also in multiple files with same schema), and follow this documentation https://help.talend.com/r/en-US/8.0/excel/extracting-d...
...abels, header is 1 lines, table is [Level 1_1]) where not IsNull([F3]); Nivel1_2: LOAD RowNo() as Key2, as "Level2_field", as "Level2_value" FROM [$(vFile)]] (ooxml, n...
