Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power query

I have 2 columns: The first column indicates my source and is a concatenation of the file name plus the as of date The second column is the record number. Here is an example:   1.  extract_09302...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Salut, Anonymous , you may try

    Text.Combine({Text.Select([Source.Name], {"0".."9"}),[Record ID]}, "_")

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Salut, Anonymous , you may try

Text.Combine({Text.Select([Source.Name], {"0".."9"}),[Record ID]}, "_")