To reflect an added column from source, to merged table

[JohnnyK]

Good day!

Kindly consider this case.

The data source is a Salesforce Report. It's merged with input data to for a new (merged) table for visual. (the Salesforce Report itself doesn’t have any role in visuals)

The Salesforce Report had 5 columns originally. (the merged table had 5 columns from it) Later a new column is added.

What would be the way to have the newly added column (from the Salesforce report) to be automatically added to the merged table?

I tried several refreshes, but the merged table still doesn't have it. Thank you.

[Greg_Deckler · Accepted solution]

@JohnnyK Is the Salesforce Report a CSV file? CSV's by default specify the number of columns in the Source step so you have to go into Advanced Editor and get rid of that.

[JohnnyK]

@Greg_Decklerthank you!

It's not a csv file. It looks like pulling from Salesforce.com directly.

But indeed in Advanced Editor that I can add in the name of the new column. Then it pops!