Hi All,
I have two Files, both being pulled into Power Query. The first file (File 1)has one Items field, the other file has a list of Item_Types (file 2). Both files expand and contract according to changes in the files information. What I am trying and failing to do is, in file 1. Add this data to an Excel Tab, no problem so far. But now I would like to add a second field that has the contents of file 2 in each of these cells, data validation.
So each Item in File 1 will belong to a Item_Type. So if a new Item appears it can be allocated to that Item_Type. It seems a simple problem that I just cannot work out. Thanks for any pointers.
I have two Files, both being pulled into Power Query. The first file (File 1)has one Items field, the other file has a list of Item_Types (file 2). Both files expand and contract according to changes in the files information. What I am trying and failing to do is, in file 1. Add this data to an Excel Tab, no problem so far. But now I would like to add a second field that has the contents of file 2 in each of these cells, data validation.
So each Item in File 1 will belong to a Item_Type. So if a new Item appears it can be allocated to that Item_Type. It seems a simple problem that I just cannot work out. Thanks for any pointers.
