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


at No comments:
Labels:

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")

at No comments:
Labels:
Subscribe to: Posts (Atom)

Snowflake - Notes

WPRKSPACES -  In September 2025, Snowflake introduced Workspaces, which combines the functionality of Worksheets, Notebooks, File Manager, Q...

  • MD5 Function in INFORMATICA
    MD5 (Message Digest Function) is a hash function in Informatica which is used to evaluate data integrity. The MD5 function uses Message-Dig...
  • CACHING in Snowflake
    Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
  • List
    #Sample   thislist = [ "apple" , "banana" , "cherry" ] print ( "MyList : " , thislist ) ​ thislist...