Expression updated with new file

Explore discuss data innovations to drive business efficiency forward.
Post Reply
phonenumber
Posts: 10
Joined: Sun Dec 22, 2024 8:54 am

Expression updated with new file

Post by phonenumber »

Now all of the copies of this expression in all of the various places it has ended up in, are wrong, and need to be found and edited to give the correct list of locations.

To remove this need for extra france phone number list work we can have the expression refer to a file, which is then updated by the user on the occasions when the list of points change.

Here is the first view of that expression where the 2nd column in my data file contains the same 4 postcodes as in the first version above.

Airport expression part 2

Now, updating the file with the new airport and simply re-running the data grid, we can see that the values in the final column have changed – mainly in this case for customers in Scotland.

Image

This is a simple example with only 4 locations, but the file could easily contain hundreds of store locations, or thousands of public transport locations etc.
Post Reply