Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I have a daily data source file that requires accessing, however each the name of the source file itself is different with a new datetime stamp appended at the end:
For example each the file has the following name followed by the YYYY-MM-DD-HH-MM-SS:
DELIVERY ADDRESS & TYPE PP32024-02-04-14-25-00
DELIVERY ADDRESS & TYPE PP32024-02-05-14-25-08
DELIVERY ADDRESS & TYPE PP32024-02-06-14-25-07
Is there a way of using a "contains" to reference the first part of the source file so that it is dynamic for all future files?
If so, how do I write this code?
Thanks!
@RD_PowerBI24 Load the files as a folder, and there before expand of binary data you can filter data using contains
Thanks Amit. However, this didn't seem to work for the text.contains function or I was doing it wrong.. As it is a cumulative file of records I found another solution which works and allows the new file to replace the previous day's one without explicit reference.
User | Count |
---|---|
64 | |
59 | |
47 | |
32 | |
31 |
User | Count |
---|---|
84 | |
73 | |
52 | |
50 | |
44 |