Forum Discussion
How do I create a column of data using a single cell of source data
Hi folks! I am connecting to a folder that contains 2 dozen excel files. Each file is idential in layout, the only difference is that some files have about 7,000 rows of data while others have over...
You can do this in the Transform File. Make your next step after the source steps be = PreviousStepName[Column2]{0}. Name that step CustomerNumber. Then make your next step's formula like:
= StepNameBeforeTheLastStep
Now you have your original table, and the CustomerNumber as a variable. You can use CustomerNumber in an AddColumn step, and that formula would be:
Table.AddColumn(PriorStepName, "Customer Number", each CustomerNumber)
--Nate
Hello Anonymous . The refresh produced one value for customer number across all of my 2 dozen excel files. This value came from the very first file. I need the customer number to be syncronized to each individual file. I'll keep working on this and restore your recommendation if I can get it to work.