Thursday, 2 December 2021

List file names in a directory by file explorer

  • Go to the specific directory where files are stored.
  • Select all files by CNTRL+A.
  • Press Shift and Right click on files
  • Select “copy as path” from right click menu
  • Paste the result in file editor


VLOOKUP - Data Cleansing - MSExcel

 =IF(ISNA(VLOOKUP($B3,G$3:G$26,1,FALSE)), "Not Present", "Present")


=IF(ISNA(VLOOKUP($D3,B$3:B$27,1,FALSE)), "Not Used", "Used")

Subscribe to: Posts (Atom)

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...

  • SQL Error : Multiple ResultSets were returned by the query
    Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
  • DATA MINING
    Data mining is the process of finding patterns from large data sets and analyzing data from different perspectives. It allows business use...