Hi Raza, I can only use 14092019 as an example, please see attached, you will need to use Transform > Split Column, first split number of c...
Hi Mynda, Found out the reasons, need to "check" the preserve column sort/filter/layout under table > External data properties, by default it ...
Hi Mynda, so you are suggesting using excel table properties instead of M Code in PQ, However when I click refresh all the total formulae are wiped...
Hi Catalin, Yes, however in real life, the Table 1 and Table 2 and subsequent tables are with different headers, by appending them together will ...
Hi Catalin, perfect ! this is exactly what I am looking for, however some users still like to import all the tabs into PQ and append it so I tho...
Hi Catalin, basically I want to just issue a M code that will consolidate all the worksheets like what Excel.CurrentWorkbook( ) did, i.e. instead...
Hi Catalin, I try to explain,, in my attached example, because the source file is in the excel itself, I can use =Excel.CurrentWorkbook( ) i...
Hi Mynda, ok thanks for your recommendation, I would unpivot and import to Qlik Sense to visualize using QS filter Thank you !
Hi Mynda , that was super fast, thanks is there any quick way to break all these sub-tables into different queries, i.e. Total Citizen one qu...
Wow Catalin, fantastic, basically this function is so powerfully can practically extract any key words in a phrases I am so grateful your patienc...