Adding a column to a source file

[thewiseguy]

Hi all - new to PQ. My source file has multiple sheets with a number fo columns that are pulled into another worksheet. I want to add a column to this source file but when i do and then try to bring the data back into the other worksheet, i get an error saying it can not find column (insert number).

How can I add a column to the source data and then refresh the data in the new worksheet to reflect the new source file with additional column?

Any help is appreciated!!

 

[Guitarmageddon]

Hi all - new to PQ. My source file has multiple sheets with a number fo columns that are pulled into another worksheet. I want to add a column to this source file but when i do and then try to bring the data back into the other worksheet, i get an error saying it can not find column (insert number).

How can I add a column to the source data and then refresh the data in the new worksheet to reflect the new source file with additional column?

Any help is appreciated!!

You are bringing two different sheets with different formatting and merging them together? What does your query and steps look like?

 

[thewiseguy]

Apologies if my terminology is off. I have attached screen shots of a few files. My source file (the file where my data sits) - this is one of the tabs within the file (catalog-decorative).

The second screen shot is where the data is pushed into (worksheet-decorative).

If I want there to be a change in the source file (a new column), then what steps do i need to take to ensure I do not have any errors?